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

121 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
bouldery1429501(None) 
boulder103411341boulder_
boulders113010031boulders
bolder94820932bo_lder_
bouldered1344482bouldered
boulderer1244402boulderer
boundary1444752boundary
bounder104215532bounder_
bounders114314112bounders
bowlder13407482bowlder_
bowlders14306492bowlders
moulder10389802moulder_
moulders11348342moulders
adultery1244223adultery
aulder7511453_aulder_
balder95318863b_alder_
bindery13459833b_indery
bladdery15344583bladdery
blubbery14294783blubbery
blunder103813153blunder_
blunders113911343blunders
blustery13368003blustery
boarder103910323boarder_
boarders11408623boarders
bobbery13438353bo_bbery
boiler84319273boil_er_
boilers93417063boil_ers
boldest102613063bo_ldest
boldly12399423bo_ld_ly
bolero8412093bo_l_ero
bolter83920753bo_lter_
bolters94017803bo_lters
bonder95324783bo_nder_
bonders104120663bo_nders
boodler103312003boodler_
boodlers113710743boodlers
bootery1238983bo_otery
border94419973bo_rder_
borders104317533bo_rders
botchery18366763botchery
boulderers1343663boulderers
bouldering1464763bouldering
boule74828043boul_e__
boules84925973boul_e_s
boulle84614613boulle__
boulles93114123boulle_s
bouncer113811333bouncer_
bouncers12309353bouncers
bounded113613763bounde_d
bounden10389453bounde_n
bouvier1277433bouvier_
bouviers1375003bouviers
bowery146012113bo__wery
bowler114217313bowl_er_
bowlers123715783bowl_ers
broidery14356083broidery
budder104314813b_udder_
budders113812103b_udders
buggery14367933b_uggery
builder1037573builder_
builders1146743builders
bulger94917353b_ulger_
bulgers105215143b_ulgers
butlery12369423b_utlery
buttery124311193b_uttery
colder95121853co_lder_
colliery13307363colliery
couldest1148353couldest
coulter94115603coulter_
coulters103614313coulters
doddery13516853do_ddery
folder104317543fo_lder_
folders113514393fo_lders
foolery1336693fool_ery
fouler93614903foul_er_
founder114312573founder_
founders123911673founders
foundry1433913found_ry
fullery13337973_fullery
gaudery1234743gau_dery
golder84417603go_lder_
holder104619653ho_lder_
holders113715903ho_lders
hounder113412233hounder_
hounders123111713hounders
louder74414603lou_der_
molder93819273mo_lder_
molders103315553mo_lders
moulded11348063moulde_d
mouldered1343753mouldered
mouldier1154963mouldier_
mouldy12437413mould__y
moulter93812423moulter_
moulters103510783moulters
older65121173_o_lder_
polder94019253po_lder_
polders103617373po_lders
poulter93712013poulter_
poulters103911053poulters
poultry1235383poul_try
pounder103314003pounder_
pounders113113283pounders
powdery16396123po_wdery
prudery1335243pru_dery
rounder83514603rounder_
rounders92613693rounders
rudery10419033_ru_dery
scullery13296333scullery
shoulder1234753shoulder_
shoulders1334233shoulders
shuddery16263413shuddery
smoulder1133443smoulder_
smoulders1243143smoulders
solder73921343so_lder_
solders83517773so_lders
soldiery12254613so_ldiery
sounder83315383sounder_
sounders93214113sounders
thundery1533823thundery
volery1237873vo_l_ery
wouldest1235483wouldest

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.423422437.4
2DLD Change Limit1461621217.25020160.3
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.71923149.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.