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 “foundling” 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
foundling143521(None) 
fondling13189351fo_ndling
founding133010791found_ing
foundlings1542911foundlings
bounding123012132bound_ing
bundling12219702_bundling
fonding123815422fo_nd_ing
fondlings14224892fo_ndlings
fonduing13245892fo_nduing
fouling113315372fou__ling
foundering1545352foundering
fuddling14247152f_uddling
funding124113662f_und_ing
groundling1343392groundling
hondling132210012ho_ndling
hounding132610052hound_ing
mounding123311262mound_ing
pounding123311472pound_ing
rounding102812282round_ing
sounding102712872sound_ing
trundling1135002trundling
wounding13249402wound_ing
youngling1463272youngling
abounding1335193abound_ing
bonding113318433bo_nd_ing
boodling121910243bo_odling
bouncing13318773boun_cing
brandling1348253brandling
bundlings13235563_bundlings
bungling12269543_bungling
candling122313873_candling
coddling13258473co_ddling
codling114418953co__dling
cofounding1743673cofound_ing
condoling13510373co_ndoling
counseling1345463counseling
counting113115273coun_ting
coupling13310783cou_pling
cuddling13287653_cuddling
curdling12228893_curdling
dandling112511733_dandling
dindling112411163_dindling
doodling11218403do_odling
doubling1238153dou_bling
dwindling15123793dwindling
fending123717603f_end_ing
feuding123410263feu_d_ing
fiddling14217873f_iddling
finding124116543f_ind_ing
flouncing1533903floun_cing
floundering1642483floundering
flunking16317773flun_king
foaling113515843fo__aling
foiling113317653fo__iling
foining113013453foin__ing
folding123912443fo_ld_ing
fondueing1443093fo_ndueing
fooling113117373fo__oling
footling12239923fo_otling
foozling21275723fo_ozling
fording123717043fo_rd_ing
fordoing1357303fo_rdoing
foredoing1456483foredoing
foulings12327943fou__lings
foundries1345693foundries
fountain1144923fountain_
fountains1245283fountains
fowling143713113fo__wling
frouncing1534763froun_cing
fudging133310013f_u_dging
fueling113615133f_u_eling
fuelling123410153f_uelling
fugling124212513f_u_gling
fulling114019703f_u_lling
fumbling16208163f_umbling
funking154013023f_un_king
funneling1344513funneling
funning113813613f_un_ning
furling114016563f_u_rling
godling103513403go__dling
grounding1236083ground_ing
groundlings1442073groundlings
gruntling1134263gruntling
handling132312713_handling
houseling1337483houseling
huddling14227293_huddling
hurdling13288013_hurdling
jouncing18336853joun_cing
journaling1843173journaling
kindling14229623_kindling
lordling1077743lo_rdling
lounging1036753loun_ging
moulding12258143mould_ing
mounting112711813moun_ting
muddling13268593_muddling
noddling11237263no_ddling
noncling11310763no_ncling
noodling10209443no_odling
outdoing1039423_outdoing
pindling122110983_pindling
poinding122510003poind_ing
ponding114317083po_nd_ing
pouncing13318883poun_cing
puddling13218033_puddling
pungling12228663_pungling
refounding1545353refound_ing
ruddling11228553_ruddling
runkling13217613_runkling
sandling102214413_sandling
soundings11266153sound_ings
spindling13136273spindling
stounding1136233stound_ing
swindling14135833swindling
swounding1434133swound_ing
toddling11187003to_ddling
tousling938793tou_sling
touzling1835503tou_zling
trindling1137133trindling
unbundling1443113unbundling
undoing9312243__undoing
undying1238503__undying
unsling8313643__unsling
windling132212263_windling
worldling1442893worldling
yodling123610253yo__dling
younglings1561723younglings

Search took 7 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 Limit1486411266.40323214.3
3Display Results1261260.0502520.0
 (SQL Overall)1786911266.87625987.6
 
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.