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

405 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
footlers11391079(None) 
footers104618331foot_ers
footler104011871footler_
footles103715711footle_s
footless113710801footless
foozlers20346071foozlers
tootlers8289501tootlers
boodlers113710742boodlers
bootlegs11325872bootlegs
bootless103410982bootless
bottlers103810012bottlers
coolers93522492coo_lers
cooters94525722coot_ers
doodlers10338842doodlers
fondlers12338022fondlers
foodless12338382foodless
foolery1336692foo_lery
footer94320772foot_er_
footgears13103072footgears
footier104115112footier_
footies103721542footie_s
footle93914382footle__
footled113610762footle_d
foozler19397592foozler_
foozles19329542foozle_s
fosters104220102fost_ers
fowlers133411202f_owlers
frothers14279812frothers
hooters104520472hoot_ers
hostlers113310482hostlers
jostlers15357682jostlers
looters74419162loot_ers
mooters93818622moot_ers
mottlers10388182mottlers
ostlers72911202_ostlers
poolers94217422poo_lers
rooters74522932root_ers
rootles73215632rootle_s
rootless83910442rootless
rootlets8308652rootlets
soothers113913432soothers
toolers74416502too_lers
tooters73818772toot_ers
tootler73511122tootler_
tootles72915602tootle_s
woolers104214022woo_lers
antlers74014743_antlers
battlers104110973battlers
beetlers1037393beetlers
blotless10347153blotless
blotters104110983blotters
boaters93419243boat_ers
bogglers12347603bogglers
boilers93417063_boilers
bolters94017803bolt_ers
boltless10338283boltless
boodler103312003boodler_
boodles103416043boodle_s
boogers104514633boo_gers
bookers134016613boo_kers
booklets14247123booklets
boomers114115913boo_mers
boomlets12246673boomlets
boonless10328353boonless
boosters104013443boosters
bootees94114473boot_ees
bootery1238983boot_ery
booties94124613bootie_s
bootleg10276633bootle_g
boozers183912443boo_zers
bothers124317753_bothers
bottler94211883bottler_
bottles94216273bottle_s
bowlers123715783_bowlers
broilers103210093broilers
brothers133410833brothers
bustlers104210613bustlers
butlers94518053_butlers
cholers124215203cho_lers
chortlers14305663chortlers
coalers94419353_coalers
coaters93525793coat_ers
coatless1039693coatless
cobblers14359593cobblers
coddlers12359173coddlers
coilers93619903_coilers
colters93522443colt_ers
cooers84324563coo__ers
cookers134619463coo_kers
cookless14258633cookless
cooler84824713coo_ler_
coopers114019483coo_pers
cooter85128613coot_er_
cooties93725733cootie_s
copters113621283copt_ers
corulers1039773corulers
costers94128333cost_ers
costless10310003costless
cotters94323443_cotters
cottiers10399153cottiers
coulters103614313coulters
couplers123311323couplers
couters93827303cout_ers
cutlers94217003_cutlers
doodler93310153doodler_
doodles93614163doodle_s
doolees83711613doo_lees
doorless936713doorless
doozers17419293doo_zers
doters74423913_dot_ers
dotters83715973_dotters
dottles83912283dottle_s
doublers11288503doublers
emoters94712873emot_ers
fablers124812613f_ablers
fagoters1234863fagot_ers
fallers103917993f_allers
falters103916473falt_ers
fartleks1533963fartleks
fathers133916503f_athers
fatless103212203f_atless
feathers143513243feathers
feelers103814743f_eelers
feetless1137383feetless
fellers104117543f_ellers
feoffers1333133feoffers
festers104121393fest_ers
fetters103517903f_etters
fettles103912733fettle_s
fiddlers13328283fiddlers
filers94623723f__ilers
fillers104320213f_illers
filters103816553filt_ers
fitters104517753f_itters
flatlets1147373flatlets
flatters113814203flatters
flitters114312173flitters
floaters112711513floaters
floggers13387863floggers
flooders12257833flooders
floorers11227573floorers
floorless1243793floorless
floppers15337463floppers
flossers11307863flossers
flouters11419273flouters
flowers133413173flo_wers
fluters103713683flut_ers
flutters114010823flutters
flytiers14254483flytiers
foamers123812103f_oamers
foamless13195843foamless
focusers13134373focusers
fodders124010753f_odders
foetors1039763foet_ors
foggers124112013f_oggers
fogless1138193f_ogless
foibles1238853foible_s
folders113514393f_olders
foleys123810463f_o_leys
folles93820473f_olle_s
fondler11348883fondler_
fondles113512613fondle_s
foodies113416753foodie_s
fooled104317823foo_le_d
fooleries1248743foo_leries
fools86824203foo_l__s
footages1239053footages
footbags1444523footbags
footballers1652233footballers
footboys1644333footboys
footed104418623foot_e_d
footgear12113063footgear
footie94718143footie__
footiest113514913footiest
footings12248833footings
footlessly1663313footlessly
footlike1537253footlike
footling12239923footling
footlockers2051723footlockers
footloose1242643footloose
footmark1743833footmark
footmarks1843583footmarks
footmen1246583footme_n
footpads1443983footpads
footrest11308853footrest
footrests12244503footrests
foots85528283foot___s
footsies1139643footsies
footslogs1342723footslogs
footsore1146063footsore
footsteps1462863footsteps
footways1744873footways
footwear14103373footwear
footwork1845813footwork
footworks1945453footworks
footworn1445163footworn
foozle18369203foozle__
foozled20346893foozle_d
foragers12349633foragers
forayers14277273forayers
forcers124215713f_orcers
fordless12289003fordless
forelegs1236613forelegs
forevers1438173forevers
forgers115218183f_orgers
forgoers1236413forgoers
forkers144615783f_orkers
forkless15267433forkless
formers128217953f_ormers
formless13248083formless
fortes95327183fort_e_s
forties104323863fortie_s
fortress1136753fortress
foster94322223fost_er_
fosterers12238023fosterers
fouler93614903f_ouler_
founders123911673founders
fowler123712583f_owler_
foyers125413133f_o_yers
fraters103517213frat_ers
fretless1138063fretless
fretters113410303fretters
frillers11349873frillers
fritters113810783fritters
froglets1235263froglets
frontiers1254993frontiers
frontless1235403frontless
frontlets1244233frontlets
frostless1235743frostless
frother133110153frother_
frotteurs1242223frotteurs
frowners14377933frowners
fuelers103912393f_uelers
fuellers11277983fuellers
fullers103817373f_ullers
fumblers15318713fumblers
furlers104214223f_urlers
furthers1436493furthers
gaolers83511563gao_lers
gobblers13308343gobblers
gogglers11276713gogglers
goiters84014443goit_ers
goobers10219623goo_bers
growlers12327093growlers
guttlers9306933guttlers
hobblers15308513hobblers
hollers103818233_hollers
hoodless12289733hoodless
hoofers134513323hoo_fers
hoofless14258013hoofless
hookers144916513hoo_kers
hookless151238363hookless
hooklets15217203hooklets
hoopers123616483hoo_pers
hoopless13279253hoopless
hooter94123933hoot_er_
hootier104915353hootier_
hoovers134312703hoo_vers
hostelers1246633hostelers
hostler103411023hostler_
howlers133312353_howlers
hustlers11349203hustlers
jogglers17356883jogglers
jolters143711993jolt_ers
jostler14288223jostler_
jostles143411143jostle_s
jotters143413803_jotters
knollers12255133knollers
knotless1264563knotless
knotters12276153knotters
kotowers1534313kotowers
loathers113310443loathers
lofters103912903loft_ers
loftless1135903loftless
loiters74116613loit_ers
lollers72713793_lollers
lookers114014073loo_kers
loopers93914033loo_pers
looter64222323loot_er_
lotters73921063_lotters
modelers1138463modelers
moilers93615203_moilers
molters93816973molt_ers
moochers15369123moochers
mooleys1236863moo_leys
mooners94015343moo_ners
moonless10278043moonless
moonlets10247473moonlets
mooter83921093moot_er_
mootness1036753mootness
mothers123717623_mothers
motleys1235683_motleys
mottler94410343mottler_
mottles93415803mottle_s
moulters103510783moulters
mouthers133811303mouthers
nestlers8359223nestlers
nettlers8307513nettlers
nobblers12318563nobblers
noodles83513193noodle_s
noosers74913923noo_sers
northers1139333northers
noters64021003_not_ers
oaters65029793_oat_ers
oglers74313183__oglers
oilers64721193__oilers
oodles73517183_oodle_s
ostler63312193_ostler_
others93918003__others
otters64021513__otters
outers64230173_out_ers
outlets73616363_outlets
outliers82610673_outliers
oxters134813273_oxt_ers
peoplers1237153peoplers
plotless10256793plotless
plotters104011553plotters
poetless1038723poetless
polers84225643_po_lers
pollers93420023_pollers
poodles103013513poodle_s
poofters1336923poofters
pooler83819843poo_ler_
porters93722703port_ers
portless10310643portless
posters93928013post_ers
pothers123818623_pothers
potters94024343_potters
pottles93816983pottle_s
potzers184010543_potzers
poulters103911053poulters
pouters94221873pout_ers
powters124015663powt_ers
prowlers13328933prowlers
quoters16369263quot_ers
rattlers83510293rattlers
rioters73615513riot_ers
rollers73117473_rollers
roofers105013903roo_fers
roofless11316733roofless
roomers95416413roo_mers
roosers74217873roo_sers
roosters83514663roosters
rooter64926033root_er_
rootier74915393rootier_
rootle63214453rootle__
rootled83410533rootle_d
rootlet73015733rootle_t
rosters73727543rost_ers
rotters74421393_rotters
routers74822873rout_ers
rustlers8339853rustlers
scooters103511033scoot_ers
scoters93313813scot_ers
scowlers13257353scowlers
settlers8289023settlers
shooters112811583shoot_ers
slotters84012403slotters
smoothers14206043smoothers
smothers13349933smothers
sooners73916643soo_ners
soother104215043soother_
soothes103917113soothe_s
sootier73916613sootier_
sorters74221133sort_ers
souters74422603sout_ers
southers114214453southers
spoilers10238633spoilers
spoolers10349363spoolers
spotless1037043spotless
spotters104313383spotters
sutlers73116973_sutlers
swotters11448483swotters
tattlers8369693tattlers
toddlers10346963toddlers
togglers10276953togglers
toilers74116263_toilers
tollers73217463_tollers
tooler63818613too_ler_
toolless836343toolless
tooter64420803toot_er_
toothless1244683toothless
tootle62613813tootle__
tootled83511043tootle_d
tootses72910773tootse_s
toters65026363_tot_ers
totters74618733_totters
touters74018353tout_ers
trollers83211213trollers
trotters83310243trotters
turtlers8258203turtlers
voters95017443_vot_ers
wobblers15327883wobblers
woodless12278453woodless
wooers93712443woo__ers
woofers133810583woo_fers
woolens10398843woo_lens
wooler93615873woo_ler_
woollens1144093woollens
yodelers1235673yodelers
yodlers11298923_yodlers
yowlers13328923_yowlers
zoogleas1843373zoogleas
zootier163611173zootier_
zosters163015413zost_ers

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.1531167915.0
2DLD Change Limit1461624057.06320694.0
3Display Results4054050.1562596.2
 (SQL Overall)1786914057.37224239.1
 
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.