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 “hosteling” 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.

131 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
hosteling133789(None) 
hostelling1446161hostelling
fostering132411262fostering
fosterling1445172fosterling
hastening13259482hastening
holstering1447082holstering
hoseying1537192hos_eying
hostessing1444572hostessing
hosting114318382host__ing
houseling1337482houseling
hoveling15189592ho_veling
hustling12228792hust_ling
jostling16207122jost_ling
bolstering1346883bolstering
bottling11279143bo_ttling
boweling143410683bo_weling
busheling1535503busheling
bustling112110063bust_ling
castling11311233cast_ling
chastening1656523chastening
chiseling1536403chis_eling
chortling1535563chort_ling
corbeling1439033corbeling
coshering15510023coshering
cosseting1239543cosseting
costing104323023cost__ing
costuming1445283costuming
doweling13279763do_weling
fastening13268603fastening
festering132413173festering
footling12239923foot_ling
fosterlings1542853fosterlings
ghosting1336463ghost__ing
gosling93312403gos__ling
haltering132212013haltering
hanseling1338063hanseling
hassling1236803has_sling
hasting114725193hast__ing
heeling113618513h__eeling
hireling121210993h_ireling
hirseling1396273hirseling
histing113720373hist__ing
hobbling16227583ho_bbling
hoeing104117023ho__e_ing
hogtieing1442863hogtieing
hogtying1633553hogt_ying
hoidening1435633hoidening
hoisting123610903hoist__ing
holing104025073ho___ling
hollering1337743hollering
holstein1145003holste_in_
holsteins1245263holste_ins
homering141512073ho_mering
hondling132210013ho_ndling
honeying1537673ho_neying
hooting113919883hoot__ing
hoovering1635753hoovering
hoppling16206763ho_ppling
hoselike15179643hos_elike
hosing103421103hos___ing
hostel93914153hostel___
hosteled1237293hostel_ed
hosteler1137283hostel_er
hostelers1246643hostelers
hostelled1345733hostelled
hosteller1245863hosteller
hostelries1345423hostelries
hostelry1443913hostel_ry
hostels103712323hostel__s
hostility1546373hostility
hotching17309313ho_tching
hotelier1137643ho_telier
hotline10712353ho_t_line
hotlink1476763ho_t_link
hotting113116523ho_t_ting
houselling1445753houselling
hovelling1636163hovelling
hovering151911143ho_vering
howling143413163ho__wling
hoydening1744353hoydening
hurtling12318313hurt_ling
justling16207253just_ling
koshering1735363koshering
listening10128953listening
lobstering1345123lobstering
loitering1039683loitering
lustering102711203lustering
mastering122315313mastering
modeling12311073mo_deling
moistening1346233moistening
morseling1238073morseling
moseying1436853mos_eying
mottling11197753mo_ttling
musteline1146973musteline
mustering122212333mustering
nestling958893nest_ling
oystering1337563oystering
pestering122315663pestering
pestling111010253pest_ling
pistoling1268493pistoling
pommeling1643873pommeling
portering122012303portering
posting105622243post__ing
posturing1238993posturing
pottering122612003pottering
restyling1337923restyling
roistering1148593roistering
rootling9269953root_ling
roweling122811123ro_weling
roystering1445413roystering
rustling9249983rust_ling
seeling83522003__seeling
shortening1445303shortening
shoveling1635553sho_veling
sistering101213753sistering
softening1365493softening
staling83925423__staling
stealing93416603__stealing
steeling93615143__steeling
sterling93615553__sterling
stewing113412493__stewing
styling112910653__styling
tasseling1035853tasseling
tootling9279523toot_ling
totaling9610303to_taling
tottering10229613tottering
toweling122910373to_weling
unsteeling1145183unsteeling
westering132112643westering
whistling1644733whist_ling
yodeling1357673yo_deling

Search took 9 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.440406115.9
2DLD Change Limit1486411318.21618091.7
3Display Results1311310.0632079.4
 (SQL Overall)1786911318.71920494.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.