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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 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
hosteler113728(None) 
hosteled1237291hosteled
hostelers1246641hostelers
hosteller1245861hosteller
hostler103411021host_ler
fosterer11239522fosterer
gospeler1173962gospeler
hastener11259132hastener
hostel93914152hostel__
hostelled1345732hostelled
hostellers1344682hostellers
hostelry1443912hostelry
hostels103712322hostel_s
hostile10312552hostile_
hostiles11312212hostiles
hostlers113310482host_lers
hotelier1137632ho_telier
hustler103410752hust_ler
jostler14288222jost_ler
ostler63312192_ost_ler
austerer838383austerer
bolsterer1145483bolsterer
bottler94211883bo_ttler
busheler1374763busheler
bustler94012573bust_ler
chastener1445703chastener
chiseler1335903chis_eler
chortler13336843chort_ler
coster84331293cost__er
costlier1038523costlier
costumer1275103costumer
eustele738193eustele_
eusteles838043eusteles
fastener11227833fastener
footler104011873foot_ler
foster94322223fost__er
fostered122210453fostered
fosterers12238023fosterers
ghostier1235383ghost_ier
ghostlier1343343ghostlier
gospelers1273683gospelers
gospeller1263753gospeller
hastened12239103hastened
hasteners12267813hasteners
hastier103916623hast_ier
heeler93917323h__eeler
hobbler143710403ho_bbler
hoister103714203hoist__er
holler93520613ho__ller
holster103512213holst__er
holstered1345883holstered
homelier1338983ho_melier
hooter94123933hoot__er
hootier104915353hoot_ier
hosel86024823hos_el__
hosels94218613hos_el_s
hoser811529763hos___er
hoseyed1436953hos_eyed
hosier94219613hos__ier
hostage113111233hostage_
hostages122311693hostages
hosted105020343host__ed
hosteling1337893hosteling
hostelries1345423hostelries
hostess103210243hoste_ss
hostessed1344353hostessed
hostesses1247173hostesses
hostilely1543313hostilely
hostly124210863host_l_y
hotel85520753ho_tel__
hoteliers1245803ho_teliers
hotelmen1344193ho_telmen
hotels94515523ho_tel_s
hotter94720083ho_t_ter
houseled1237283houseled
hoveled14209293ho_veled
hoverer13319823ho_verer
however1634513ho_wever
howler123514313ho__wler
howsoever1851993howsoever
hustle93113993hust_le_
hustled113210133hust_led
hustlers11349203hust_lers
hustles103414173hust_les
jostle13319863jost_le_
jostled15267083jost_led
jostlers15357683jost_lers
jostles143411143jost_les
listener8158313listener
lobsterer1144033lobsterer
loiterer837083loiterer
modeler1039293mo_deler
moistener1145843moistener
mottler94410343mo_ttler
nestler73510453nest_ler
oftener1035923_oftener
ostlers72911203_ost_lers
oysterer1136103oysterer
pesterer102412713pesterer
posteen93512623poste_en
poster84129173post__er
posturer1038923posturer
potterer102310263potterer
roisterer946433roisterer
rostella845493rostella
rostellar943973rostellar
roster64329083rost__er
rottener8216973rottener
rustler73512343rust_ler
shortener1245773shortener
shoveler14165583sho_veler
softener1145613softener
staler64025823__staler
stealer72913983__stealer
steer55423863__ste_er
stelar64013863__stelar
stele55026843__stele_
steles63725663__steles
styler94013303__styler
tootler73511123toot_ler
totterer8217793totterer
whistler1496313whist_ler
whosever1742893whos_ever
whosoever1841983whosoever
yodeler1136343yo_deler
zoster153715853zost__er

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621267.40619735.6
3Display Results1261260.0502520.0
 (SQL Overall)1786911267.87622688.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.