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

345 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
doublers1128849(None) 
doubler103110081doubler_
doubles103113351double_s
doublets11257361doublets
doubters11257371doubters
cobblers14359592cobblers
couplers123311312couplers
dabblers13379362dabblers
daubers104610422daub_ers
dibblers13377582dibblers
dobbers123513242do_bbers
doodlers10338842doodlers
double94013992double__
doubled11289952double_d
doublet103914032double_t
doublure1142582doublure
doublures1242562doublures
doubter10298352doubter_
doubtless1243312doubtless
dousers84817272dou_sers
drubbers13386022drubbers
dubbers124011822d_ubbers
duelers83412052d_uelers
gobblers13308342gobblers
hobblers15308512hobblers
nobblers12318562nobblers
redoublers1342412redoublers
roubles93413502rouble_s
troublers1134982troublers
wobblers15327882wobblers
amblers115213563_amblers
babblers113510353babblers
baubles113611863bauble_s
blubbers11408143blubbers
bobbers103614283bo_bbers
bobbles104514913bobble_s
bogglers12347603bogglers
boilers93417063bo_ilers
bombers134512593bomb_ers
bomblets1436023bomblets
boodlers113710743boodlers
bottlers103810013bottlers
boucles113113003boucle_s
boulders113010023boulders
boules84925973bou_le_s
boulles93114123boulle_s
bouncers12309353bouncers
bounders114314103bounders
bouviers1375003bouviers
bowlers123715783bo_wlers
bubblers11448943bubblers
buglers105115323_buglers
bumblers143710733bumblers
burblers12399263burblers
burlers94120273_burlers
butlers94518053_butlers
cablers114416713_cablers
clubbers14378573clubbers
coalers94419333co_alers
cobbers134114753co_bbers
cobbler133311823cobbler_
cobbles133814823cobble_s
cobles104622883co_ble_s
coddlers12359163coddlers
coilers93619903co_ilers
combers134516613comb_ers
coolers93522493co_olers
corulers1039763corulers
couchers153513843couchers
coughers14399953coughers
coulees9315503cou_lees
coulters103614303coulters
counters103320183counters
coupler114713013coupler_
couples115317053couple_s
couplets12389873couplets
couriers103213163couriers
coursers104412293coursers
courters103015363courters
couters93827283cou_ters
crullers1047293crullers
cubers105318343_cub_ers
cullers93418843_cullers
curlers94218063_curlers
cutlers94216993_cutlers
dabbers123813213d_abbers
dabbler124012153dabbler_
dabbles124514773dabble_s
dandlers103912053dandlers
danglers103610593danglers
dauber94112013daub_er_
daubery13396213daub_ery
daubes94913703daub_e_s
daubier1037093daubier_
daunders10278473daunders
daunters9329843daunters
dawdlers13375673dawdlers
dazzlers1733233dazzlers
dealers84118613d_ealers
decouplers1573083decouplers
defilers12439473defilers
diablery1443233diablery
dialers83614293d_ialers
diallers957773diallers
dibbers124013173d_ibbers
dibbler124510283dibbler_
dibbles124013333dibble_s
diddlers11359153diddlers
disablers1255803disablers
doable93115243doable__
dobber114015413do_bber_
dobbies124113063dobbie_s
dobies94422083do_bie_s
doblas93812293do_bl_as
doblons1037043do_blons
dockers143715003do_ckers
dodders105511793do_dders
dodgers105213823do_dgers
doers65225713do___ers
doffers14359853do_ffers
doggers104413433do_ggers
doglegs1034783do_glegs
dogsleds1142913dogsleds
doles67843753do__le_s
dollars83311023do_llars
dolors75115313do__lors
dongles93212873dongle_s
doobies103915673doobie_s
doodler93310153doodler_
doodles93614163doodle_s
doolees83711613do_olees
doorless936713doorless
doozers17419293do_ozers
dopers95522483do__pers
dormers104313913do_rmers
dorpers104113163do_rpers
dorsers83516293do_rsers
dosers75723633do__sers
dossers84516233do_ssers
dossiers9318043dossiers
doters74423913do__ters
dotters83715973do_tters
dottles83912283dottle_s
doubleness1345763doubleness
doubleton1252843doubleton
doubletons1352863doubletons
doubling1238153doubling
doubloon1143273doubloon
doubloons1242813doubloons
doubly12328963doubl__y
doubted11307483doubte_d
doubts968733doub__ts
douceurs1142783douceurs
douches134315233douche_s
doulas75114993dou_l_as
dourer74215273dou_rer_
dourness947683dourness
douser75621633dou_ser_
douses74928933dou_se_s
douzepers2142043douzepers
dowagers1334893dowagers
dowers104523293do__wers
downers113912773do_wners
downless1236363downless
dowsers115013523do_wsers
doyleys14384923do_yleys
dozers164815423do__zers
drawlers12307313drawlers
dribblers14274453dribblers
driblets11266093driblets
drillers9429713drillers
drubber12357863drubber_
drudgers11326843drudgers
drumbles13277723drumble_s
drummers13316163drummers
druthers1275793druthers
dubber113814553d_ubber_
duckers143214713d_uckers
dueler74213683d_ueler_
duellers9268223duellers
duffers143410093d_uffers
duikers12369383d_uikers
duller74017703d_uller_
dumpers123412663d_umpers
dunkers123512193d_unkers
dupers94615603d_u_pers
dusters84918353d_usters
dwellers12356083dwellers
enablers10196913enablers
fablers124812613_fablers
flubbers15346893flubbers
foibles1238853foible_s
fondlers12338023fondlers
footlers113910793footlers
foozlers20346073foozlers
fouler93614903fou_ler_
founders123911663founders
fowlers133411203fo_wlers
fuelers103912393_fuelers
fullers103817373_fullers
fumblers15318713fumblers
furlers104214223_furlers
gabblers134110083gabblers
gamblers13369733gamblers
garblers113810283garblers
gobbler123310023gobbler_
gobbles123512583gobble_s
goblets103210183go_blets
gogglers11276713gogglers
goobers10219613goob_ers
gougers94911763gou_gers
grubbers13316193grubbers
gruelers936173gruelers
grumblers14245023grumblers
haulers104012443hau_lers
hobbers143512343ho_bbers
hobbler143710403hobbler_
hobbles143313783hobble_s
hollers103818233ho_llers
hostlers113310483hostlers
hounders123111703hounders
housers104717813hou_sers
howlers133312353ho_wlers
hullers103616263_hullers
humblers15379803humblers
hurlers103714323_hurlers
jobbers182911133jo_bbers
jobless16237563jo_bless
jogglers17356883jogglers
jostlers15357683jostlers
joules134116823jou_le_s
jousters153210403jousters
jumblers19358323jumblers
krullers1234133krullers
lobbers113713933lo_bbers
lobbyers1533193lobbyers
lobules92510813lobule_s
lollers72713793lo_llers
loungers9449003loungers
louvers10359103lou_vers
lubbers113913723_lubbers
lullers73213353_lullers
marblers12319233marblers
maulers94213303mau_lers
mobbers133610923mo_bbers
modelers1138463modelers
moilers93615203mo_ilers
mottlers10388183mottlers
moulders11348333moulders
moulters103510773moulters
mounters103712493mounters
mourners1036913mourners
mousers95216443mou_sers
mouthers133811303mouthers
mullers93217303_mullers
mumblers14328763mumblers
nibblers12306543nibblers
nobbler113211183nobbler_
nobbles114014523nobble_s
nobler83713453no_bler_
nobles83319723no_ble_s
nombles113212343nomble_s
nounless837253nounless
oglers74313183_o_glers
oilers64721193_o_ilers
ombers104214393_omb_ers
orbless937493_orbless
ostlers72911203_ostlers
ousters74122773_ousters
outbless1037963_outbless
outers64230163_ou_ters
outlets73616363_outlets
outliers82610673_outliers
polers84225643po__lers
pollers93420023po_llers
poolers94217423po_olers
poulters103911043poulters
pouncers12349203pouncers
pounders113113263pounders
pourers93513673pou_rers
pouters94221863pou_ters
pulers83820283_pu_lers
pullers93618483_pullers
rabblers123810853rabblers
ramblers124010373ramblers
redoubler1242973redoubler_
redoubles1244263redouble_s
robbers112814153ro_bbers
robles85321693ro_ble_s
rollers73117473ro_llers
rouble83913313rouble__
roughers12329173roughers
rounders92613683rounders
rousers75220133rou_sers
rousters84315653rousters
routers74822853rou_ters
rubbers113913183_rubbers
rubles83921703_ruble_s
rulers64317093_ru_lers
rumblers123610743rumblers
scullers103510473scullers
slubbers12349943slubbers
snubbers12326673snubbers
sobbers114114253so_bbers
sobers85218853so_b_ers
solubles1065893soluble_s
soulless8218763soulless
sounders93214103sounders
soupless10268463soupless
souters74422583sou_ters
southers114214453southers
stablers103611143stablers
stumblers1334373stumblers
subers85722643_sub_ers
sublets92616703_sublets
sutlers73116973_sutlers
toddlers10346953toddlers
togglers10276953togglers
toilers74116263to_ilers
tollers73217453to_llers
tombless1236773tombless
toolers74416503to_olers
tootlers8289503tootlers
touchers133611203touchers
tourers73512733tou_rers
tousles74113933tousle_s
touters74018333tou_ters
touzles16359223touzle_s
troubler1035283troubler_
troubles1057183trouble_s
tubbers113411243_tubbers
tubers85017023_tub_ers
tumblers123110623tumblers
undoubles1243923undouble_s
vouchers16418623vouchers
wabblers15398993wabblers
warblers13319103warblers
wobbler14329823wobbler_
wobbles143412433wobble_s
woolers104214023wo_olers
yodelers1235673yodelers
yodlers11298923yo_dlers
youngers12336933youngers
younkers15295763younkers
yowlers13328923yo_wlers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623458.32617554.9
3Display Results3453450.1562211.5
 (SQL Overall)1786913458.63820686.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.