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 “hostel” with Change Limit: [1] [2] [3]

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

66 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
hostel9391415(None) 
hosel86024811hos_el
hosted105020341hosted
hostels103712311hostels
hotel85520751ho_tel
boatel84314092boatel
botel75121862bo_tel
costal85419512costal
costed95623112costed
coster84331292coster
costrel9310372costrel
dossel74813642dossel
dottel73610892dottel
foster94322222foster
ghosted1236272ghosted
gospel936532gospel
hassel95614212hassel
haste85927862haste_
hasted105125282hasted
hasten95718562hasten
hastes95727072hastes
histed104420242histed
hoisted113411292hoisted
hoister103714202hoister
holster103512212holster
hooted104422662hooted
hooter94123932hooter
horste94817412horste_
horstes104516112horstes
hose76547242hos_e_
hosed95830982hos_ed
hosels94218602hos_els
hosen85623882hos_en
hoser811529762hos_er
hoses85443172hos_es
hosey116127022hos_ey
hosier94219612hosier
host77852832host__
hosta85917832host_a
hostas94515822hostas
hosteled1237292hosteled
hosteler1137282hosteler
hostelry1443912hostelry
hostess103210242hostess
hostile10312552hostile
hostler103411022hostler
hostly124210862hostly
hosts85526702host_s
hotels94515512ho_tels
hotted104319942hotted
hotter94720082hotter
housel95217042housel
hovel115017682ho_vel
hustle93113992hustle
jostle13319862jostle
listel64214742listel
losel54419422los_el
moste75925082moste_
motel76623242mo_tel
osteal6312962_osteal
pastel85918712pastel
postal84317532postal
posted93722492posted
poster84129172poster
roster64329082roster
zoster153715852zoster

Search took 3 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 Filter178691825510.330541487.9
2DLD Change Limit82551662.20337472.1
3Display Results66660.0302200.0
 (SQL Overall)178691662.56369719.5
 
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.