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

99 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
bakings14431202(None) 
backings174012211backings
baking135626621baking_
bankings15489401bankings
lakings124713511lakings
makings145413161makings
takings124512571takings
ablings1038742ablings
agings86312672_agings
askings12519172askings
baaing94916162baaing_
backing165523442backing_
baggings13307522baggings
baling94829692baling_
balking143717352balking_
bangs85627772ba__ngs
baning95127832baning_
banking144621352banking_
baring95135852baring_
barking144724182barking_
barongs105310832barongs
bashings144311242bashings
basing95427662basing_
basins85722762basin_s
basking144718612basking_
bastings114214692bastings
bating95132252bating_
battings114010572battings
baying125222582baying_
beadings123711782beadings
bearings113912252bearings
beatings114113232beatings
beings94613032b_eings
biking135018172biking_
bikinis13346202bikinis
blackings18316762blackings
bladings12337752bladings
bluings10327962bluings
boatings113710112boatings
bodings113711652bodings
boings96416872b_oings
bookings15358732bookings
borings103614242borings
bowings133612002bowings
boxings17429162boxings
bracings13369292bracings
braking143917712braking_
breakings16297062breakings
brings94618432b_rings
brokings15317712brokings
busings103711222busings
caking134624672caking_
calkings15289222calkings
casings104013512casings
cavings134712542cavings
darings93713652darings
earings84517712earings
eatings84616442eatings
facings134511262facings
fadings12469302fadings
faking145520982faking_
gamings114610912gamings
gaskings14427472gaskings
gatings95212822gatings
hawkings19336132hawkings
hayings14379392hayings
hazings20378342hazings
kings105825562__kings
lacings105013652lacings
ladings93814132ladings
laking115027042laking_
lawings113611472lawings
likings12539412likings
making134823852making_
markings153410242markings
maskings15448752maskings
matings104516212matings
mayings134410512mayings
packings174310062packings
pagings114411062pagings
palings103915822palings
parings104219212parings
parkings153610682parkings
pavings134011632pavings
racings105015132racings
raking114728422raking_
rankings13389172rankings
ratings84217412ratings
ravings114614502ravings
sackings15389632sackings
savings114412952savings
sayings113610832sayings
taking114725952taking_
takins105117402takin_s
talkings13358402talkings
vikings15386622vikings
waking144821382waking_
walkings16327312walkings
waxings18366452waxings

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671993.18633795.0
3Display Results99990.0303300.0
 (SQL Overall)178691993.59249746.9
 
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.