Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hosteller” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hosteller124583(None) 
hosteler1137271hoste_ler
hostelled1345701hostelled
hostellers1344651hostellers
gospeller1263742gospeller
hosteled1237282hoste_led
hostelers1246632hoste_lers
hostler103411022host__ler
hotelier1137632ho_telier
rostellar943962rostellar
busheller1443523busheller
chiseller1443963chis_eller
compeller1546293compeller
costlier1038523cost_lier
dispeller12146973dispeller
distiller1046663distiller
foreteller1353303foreteller
fosterer11239523foste_rer
ghostlier1343343ghost_lier
gospeler1173963gospe_ler
gospellers1363013gospellers
hastener11259133haste_ner
heller93322513h___eller
holler93520613ho___ller
homelier1338983ho_melier
hostel93914153hoste_l__
hosteling1337893hosteling
hostelling1446163hostelling
hostelries1345423hostelries
hostelry1443913hoste_lry
hostels103712313hoste_l_s
hostessed1344353hostessed
hostesses1247173hostesses
hostile10312553host_ile_
hostilely1543313hostilely
hostiles11312213host_iles
hostlers113310483host__lers
hoteliers1245803ho_teliers
hotelmen1344193ho_telmen
houselled1346193houselled
hovelled15146843ho_velled
hustler103410753hust__ler
installer945003installer
instiller944943instiller
jostler14288223jost__ler
modeller1136613mo_deller
ostler63312193_ost__ler
reseller83412223res_eller
roselle7310243ros_elle_
roselles8310713ros_elles
rostella845493rostell_a
rostellum1152833rostellum
seller63824593__s_eller
sheller103515883__sheller
shoveller15174543sho_veller
smeller94212783__smeller
sneller73512843__sneller
speller95415143__speller
stealer72913973__stealer
stellar72610423__stellar
stiller73414293__stiller
sweller103012463__sweller
teller63519813___teller
yodeller1244853yo_deller

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit148641647.03021143.8
3Display Results64640.0331939.4
 (SQL Overall)178691647.48623870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.