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

393 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
warblers1331910(None) 
garblers113810281garblers
marblers12319231marblers
wabblers15398991wabblers
warbler123211461warbler_
warbles123215561warble_s
warslers11328071warslers
amblers115213562_amblers
babblers113510352babblers
barbers114317502barb_ers
barbless12318712barbless
burblers12399262burblers
cablers114416712ca_blers
carolers103314172carolers
dabblers13379362dabblers
fablers124812612fa_blers
gabblers134110082gabblers
gamblers13369732gamblers
garbler104012562garbler_
garbles104016922garble_s
garbless11388252garbless
garglers10418262garglers
marbler113511672marbler_
marbles114516652marble_s
rabblers123810852rabblers
ramblers124010372ramblers
wabbler143511922wabbler_
wabbles144013992wabble_s
waddlers13298332waddlers
wafflers17306322wafflers
wailers103916812wa_ilers
walers94824492wa__lers
wambles143714022wamble_s
wanglers123310032wanglers
warble113516602warble__
warbled133212162warble_d
warders113416812war_ders
wardless12249302wardless
warless104015102war_less
warmers124514292war_mers
warners103315562war_ners
warpers123413582war_pers
warsler10289892warsler_
warsles103413642warsle_s
warstlers12284712warstlers
wartless11279922wartless
wobblers15327882wobblers
abler75624313_a_bler_
ables75935543_a_ble_s
ambeers11428923_ambeers
ambers104519583_amb_ers
ambler104916453_ambler_
ambles105121863_amble_s
anglers84014823_anglers
antlers74014743_antlers
arables91814983_arable_s
arbiters1038853_arbiters
arbores94016033_arbores
arbors84717883_arb_ors
arbours93910043_arbours
archers124414573_archers
argles75218483_argle_s
arguers8489033_arguers
arles56735743_ar_le_s
armers85520273_ar_mers
armless9369943_armless
armlets94610063_armlets
artless73712513_artless
ashlers10319583_ashlers
awarders1245073awar_ders
babbler104012823babbler_
babbles104416323babble_s
bafflers16356593bafflers
bailers94221353ba_ilers
balers85626943ba__lers
ballers94421013ba_llers
barbells12368823barbells
barbels114514433barb_els
barber104419323barb_er_
barbes104526233barb_e_s
barbets114915853barb_ets
barbies114519593barbie_s
barbules1238043barbule_s
barkers134318513bar_kers
barkless14318023barkless
barless94317003bar_less
barleys125011843bar_leys
barriers104311893barriers
barters94223053bar_ters
battlers104110973battlers
baubles113611863bauble_s
bawlers124412733ba_wlers
birlers93813003bir_lers
brabblers12335563brabblers
brawlers13408643brawlers
bubblers11448943bubblers
bumblers143710733bumblers
burbler114412423burbler_
burbles114916803burble_s
burlers94120273bur_lers
cabers105023923ca_b_ers
cabler104519173ca_bler_
cables104527553ca_ble_s
cablets114216343ca_blets
cacklers163710703cacklers
cajolers17267133cajolers
callers94221963ca_llers
cambers134017443camb_ers
candlers114214103candlers
carders104820353car_ders
careers95218783car_eers
careless102813633careless
carers85133963car__ers
carles85435083car_le_s
carless95118493car_less
caroler93816753caroler_
carollers1137703carollers
carpers114521253car_pers
carriers103614203carriers
carters95327263car_ters
carvers124817543car_vers
cavilers1348113cavilers
circlers1235353circlers
cobblers14359593cobblers
corulers1039773corulers
crabbers14358753crabbers
cradlers11309203cradlers
crawlers13309013crawlers
curbers115514383curb_ers
curdlers11368493curdlers
curlers94218073cur_lers
dabbers123813213da_bbers
dabbler124012153dabbler_
dabbles124514773dabble_s
dandlers103912053dandlers
danglers103610593danglers
darbars10510093darb_ars
darbies104216983darbie_s
darers75921873dar__ers
darkles124011933darkle_s
darners83815773dar_ners
darters84017613dar_ters
dartles84014133dartle_s
daubers104610423daub_ers
dawdlers13375673dawdlers
dazzlers1733233dazzlers
dibblers13377583dibblers
doublers11288503doublers
drawlers12307313drawlers
earless74316073ear_less
earners74016453ear_ners
enablers10196913enablers
fabler116115813fa_bler_
fables114921673fa_ble_s
fallers103917993fa_llers
farcers124713443far_cers
farers95924053far__ers
farles96025783far_le_s
farmers124315263far_mers
farriers113610743farriers
fartleks1533963fartleks
fumblers15318713fumblers
furlers104214223fur_lers
gabbers124612833ga_bbers
gabbler124013303gabbler_
gabbles124415413gabble_s
gables94222333ga_ble_s
gambiers13337073gambiers
gambler123612683gambler_
gambles124016203gamble_s
gaolers83511563ga_olers
garble94118453garble__
garbled114512803garble_d
gargler93710263gargler_
gargles94214893gargle_s
garners83815993gar_ners
garters84218253gar_ters
girdlers10195403girdlers
gobblers13308343gobblers
grabbers13337883grabbers
grabblers14345513grabblers
hacklers173710303hacklers
hagglers13326623hagglers
hailers104017263ha_ilers
halers94926923ha__lers
handlers124014143handlers
harborers1446913harborers
harbors12412413harb_ors
harbours1346923harbours
harmers124116593har_mers
harmless1337403harmless
harpers124916203har_pers
harriers113712433harriers
harslets1137833harslets
haulers104012443ha_ulers
herbless1336663herbless
hobblers15308513hobblers
humblers15379803humblers
hurdlers12337493hurdlers
hurlers103714323hur_lers
jabbers183610583ja_bbers
jailers144114043ja_ilers
janglers16319373janglers
jumblers19358323jumblers
labelers10249413labelers
ladlers84613573la_dlers
lambers113817113lamb_ers
landlers94312833landlers
larders83516943lar_ders
larkers113014513lar_kers
mailers94420333ma_ilers
manglers113311903manglers
marble104219103marble__
marbled123212113marble_d
marbleise1343483marbleise
marblier1256343marblier_
marchers153710813marchers
mariners103113873mariners
markers133516103mar_kers
marrers93414313mar_rers
marriers103312473marriers
martlets103310483martlets
maulers94213303ma_ulers
mumblers14328763mumblers
nabbers113710463na_bbers
nailers73215893na_ilers
nibblers12306543nibblers
nobblers12318563nobblers
oarless73913373oar_less
orbless937493_orbless
paddlers12329153paddlers
parables121613573parable_s
paraders113113123paraders
pardners11269203pardners
parers85530743par__ers
parkers133816873par_kers
parles86334413par_le_s
parleys125212383par_leys
parlors9312923par_lors
parolees104313993parolees
paroles95025893parole_s
parriers103612913parriers
parsers94118153par_sers
parsleys1335093parsleys
partiers103514253partiers
partlets102811523partlets
partners102711143partners
partyers13277763partyers
pearlers1039033pear_lers
purflers13216973purflers
rabbler113514093rabbler_
rabbles113517973rabble_s
rafflers14317373rafflers
railers74420673ra_ilers
rambler113313263rambler_
rambles113118313ramble_s
rattlers83510293rattlers
ravelers113310863ravelers
rulers64317093__rulers
rumblers123610743rumblers
sabers85224733sa_b_ers
sables85026693sa_ble_s
saddlers10289753saddlers
sailers73822323sa_ilers
samplers12299403samplers
snarlers8298753snar_lers
sparklers15315643sparklers
stablers103611153stablers
startlers9236743startlers
swabbers15316743swa_bbers
swarmers1346323swar_mers
tabers84621573ta_b_ers
tables84524893ta_ble_s
tablets94714383ta_blets
tacklers143010773tacklers
tailers73720183ta_ilers
talers64628153ta__lers
tanglers92911973tanglers
tarriers83411713tarriers
tarsiers8298533tarsiers
tartlets8289663tartlets
tattlers8369693tattlers
trailers82912933trailers
trawlers113310203trawlers
tumblers123110623tumblers
turtlers8258203turtlers
twaddlers14343613twaddlers
twanglers1363433twanglers
twirlers11274303twir_lers
variers103712663var_iers
varlets10411573var_lets
verbless1336033verbless
wabble133714843wabble__
wabbled153311443wabble_d
wabblier15375493wabblier_
wadders123812443wa_dders
waddler124010793waddler_
waddles124314843waddle_s
waders109120653wa__ders
wafers124316153wa__fers
waffler16377783waffler_
waffles16329983waffle_s
wafters134112813wa_fters
wageless1237173wageless
wagerers12247613wagerers
wagers105122213wa__gers
waggers124613083wa_ggers
waggles123812003waggle_s
wagoners1235473wagoners
wailer93720333wa_iler_
waisters113811523waisters
waiters104218623wa_iters
waivers133410053wa_ivers
wakeless1536473wakeless
wakeners1535843wakeners
wakers134822503wa__kers
waler84229293wa__ler_
wales86142843wa__le_s
walkers143411483wa_lkers
wallets103914833wa_llets
waltzers2034003waltzers
wamble134415753wamble__
wambled153610753wamble_d
wamblier15275733wamblier_
wanders114221333wa_nders
wangler113312653wangler_
wangles113416933wangle_s
wankers144514713wa_nkers
wanters104420093wa_nters
warbling14198943warbling
wardens113711903war_dens
warder104020273war_der_
wardress12256163wardress
wares88250583war__e_s
warfares1436683warfares
warier93722893war_ier_
wariness11313223wariness
warlord1136293war_lord
warlords1245303war_lords
warmakers1845633warmakers
warmer113816743war_mer_
warmness1337063warmness
warner93717223war_ner_
warper114015583war_per_
warpowers1744563warpowers
warreners1236203warreners
warrens103810893war_rens
warriors1135363warriors
warsle93112923warsle__
warsled112910443warsle_d
warstler11275933warstler_
warstles11368803warstle_s
wartier103413913wartier_
washers134517523wa_shers
wasters104026593wa_sters
watchers163511793watchers
waterers112312793waterers
waters95030643wa__ters
wattles103814073wattle_s
wattless11268723wattless
waveless1437483waveless
wavelets1436153wavelets
waverers14318613waverers
wavers125022483wa__vers
waxers164014313wa__xers
wayless13308243wa_yless
wearables14155013wearable_s
wearers104615903wear__ers
weariless1234763weariless
webers11310943w_eb_ers
webless1237003w_ebless
whalers13529713w_halers
wheelers14287743wheelers
whirlers14286053whirlers
wigglers13257213wigglers
willers103517913w_illers
wimbles143010853wimble_s
wireless11249633wireless
wirers94617893wir__ers
wobbler14329823wobbler_
wobbles143412433wobble_s
woolers104214023w_oolers
wordless12258843wordless
workers144612693wor_kers
workless15276803workless
wormers124012573wor_mers
worriers11257813worriers
wranglers1344283wranglers
wrappers15306933wrappers
writers105513493w_riters
yabbers14389353ya_bbers
yarders113211593yar_ders
yarners104312203yar_ners

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.436409841.7
2DLD Change Limit1461623937.30020022.2
3Display Results3933930.1562519.2
 (SQL Overall)1786913937.89222642.0
 
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.