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

450 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
drainers9281125(None) 
drainer83012841drainer_
grainers93012071grainers
trainers83114641trainers
braiders114110572braiders
branners104010922branners
briners94315632br_iners
daikers124010312d_aikers
damners104112112d_amners
darners83815772d_arners
definers124211192definers
detainers10269102detainers
diners75525952d__iners
diviners12308352diviners
drabness1135802drabness
drafters12338532drafters
draggers11357392draggers
dragnets10136562dragnets
drained93713252draine_d
drains73719402drain__s
drapers105313352dra_pers
drawers113610072dra_wers
drawlers12307312drawlers
driers74516732dr_i_ers
drinkers13277822dr_inkers
drivers114412792dr_ivers
droners84114382dr_oners
drowners12428272drowners
gainers84214592_gainers
grainer83714062grainer_
mariners103113862mariners
ordainers1055112ordainers
praisers103410832praisers
prawners1346002prawners
raiders84615142_raiders
railers74420662_railers
raisers73617392_raisers
ruiners74213022_ruiners
stainers83212172stainers
strainers9510382strainers
trailers82912922trailers
trainees82712062trainees
trainer73316792trainer_
aiders74524633__aiders
aimers84621913__aimers
airers64922313__airers
airliners945983airliners
aivers94822323__aivers
aliners74717723_aliners
arbiters1038853arbiters
armigers1135703armigers
arraigners11142683arraigners
arrivers11137003arrivers
arsines73518823arsine_s
artiness81615413artiness
attainers9115593attainers
awaiters1146643awaiters
bailers94221353_bailers
baiters94619313_baiters
banners94018713_banners
bargainers1343873bargainers
biners85023633__biners
bracers114616703bra_cers
braggers12327903braggers
braider105112993braider_
braillers1135553braillers
brained103816103braine_d
brainier102510233brainier_
brainless1136403brainless
brains85125473brain__s
braises93818873braise_s
braizes183112453braize_s
branders114313093branders
branner94212373branner_
brasiers103710513brasiers
bravers124715523bra_vers
brawlers13408643brawlers
brayers124511903bra_yers
brazers184513943bra_zers
braziers19397193braziers
bribers114111503br_ibers
briers85319733br_i_ers
briner84519043br_iner_
brines85028853br_ine_s
bringers112811073br_ingers
broiders114211193broiders
broilers103210093broilers
bruisers10307953bruisers
bruiters10329143bruiters
byliners1334753byliners
caners84629203_ca_ners
canners93822663_canners
carabiners1445073carabiners
chaines124518733chaine_s
claimers12298743claimers
coiners93620753_coiners
crabbers14358753crabbers
crackers164111723crackers
cradlers11309203cradlers
crafters13419953crafters
crammers14369353crammers
cranes84330753cra_ne_s
crappers144011023crappers
crashers134013233crashers
craters95021893cra_ters
cravers124416563cra_vers
crawlers13309013crawlers
crayoners1444503crayoners
craziness2037383craziness
criers83918583cr_i_ers
cringers112511873cr_ingers
crooners103911393crooners
crowners133710753crowners
cruisers10438283cruisers
dabbers123813213d_abbers
dackers143417043d_ackers
daggers103714913d_aggers
daiker115113033d_aiker_
daises74318983d_aise_s
dammers123214273d_ammers
damner95213433d_amner_
dampers123915693d_ampers
dancers103413093d_ancers
danders93921183d_anders
dangers94818213d_angers
darers75921873d_a_rers
darings93713653darin_gs
darkeners1435153darkeners
darkness13247343darkness
darnels83710433d_arnels
darner74017303d_arner_
darters84017603d_arters
dashers115016863d_ashers
daters74827373d_a_ters
daubers104610423d_aubers
daunders10278473d_aunders
daunters9329853d_aunters
deadeners1146283deadeners
deadness1039233deadness
deafness1236213deafness
deairs74013783deai__rs
dealers84118613dea_lers
deanery1137613dea_nery
dearness939973dearness
deboners11268113deboners
deciders123510753deciders
decliners12358613decliners
defiers113913993defi_ers
defilers12439473defilers
definer114413773definer_
defines114118683define_s
deicers103612733d_eicers
delaines9312963delaine_s
delivers123310753delivers
deniers84515183deni_ers
derangers1136703derangers
deriders102411853deriders
deringers1137183deringers
derivers123811363derivers
derringers1243843derringers
designers1136003designers
desirers939263desirers
detailers10257253detailers
detainees10267153detainees
detainer92910793detainer_
devisers12339863devisers
dewiness1238453dewiness
dialers83614303dia_lers
diallers957773diallers
diamines11311643diamine_s
diapers104713913dia_pers
diasters92913183diasters
diazines1838713diazine_s
dicers94720743d__icers
dikers114418793d__ikers
dimers94321093d__imers
dinars75417563d__inars
diner65632903d__iner_
dinero75612643d__inero
dineros83812333d__ineros
dines66449153d__ine_s
dingers94321383d__ingers
dinners83915443d_inners
dirtiness1039473dirtiness
disinters1039713disinters
distrainers1255053distrainers
divers105024963d__ivers
dividers13257213dividers
diviner11369883diviner_
divines113514723divine_s
domaines11611063domaine_s
domineers1244673domineers
domines102918973domine_s
dopiness11289973dopiness
dorkiness14248053dorkiness
downers113912773d_owners
doziness18228553doziness
drabber12438593drabber_
drabbets13294823drabbets
dracenas1145793dracenas
draftees12225253draftees
drafter11449433drafter_
draftiness1444863draftiness
dragees9359483dra_gees
dragger10309173dragger_
draglines1145993dragline_s
dragnet91211433dragne_t
dragonets11134503dragonets
dragsters1134333dragsters
drails74716953drai__ls
drain65222893drain___
drainage1045783drainage
drainages1145503drainages
draining103312673draining
drakes114715863dra_ke_s
draper94315693dra_per_
drapery13387943dra_pery
drapes95419653dra_pe_s
drawbars1483103drawbars
drawees11378363dra_wees
drawer104711363dra_wer_
drawings13386283drawin_gs
drawler11338593drawler_
dreamers11369003dreamers
dreaminess1345313dreaminess
dreariness1146283dreariness
dredgers11256093dredgers
dreidels1033213dreidels
dressers9359863dressers
drier64423963dr_i_er_
dries64733673dr_i_e_s
drifters12417913drifters
drillers9429723drillers
drinker12349483dr_inker_
drinks116810713dr_in_ks
drippers13327943drippers
drivels11397923dr_ivels
driver104714493dr_iver_
drives105117113dr_ive_s
droner74717673dr_oner_
drones75023433dr_one_s
droppers13318603droppers
drovers115212643dr_overs
drowner11369803drowner_
drubbers13386033drubbers
drudgers11326853drudgers
druidess1043083druidess
drummers13316163drummers
druthers1275793druthers
dryers10449273dr__yers
dryness11114783dr_yness
duikers12369383d_uikers
dwines105013103d_wine_s
earners74016453_earners
eloiners8128153eloiners
entrainers1086963entrainers
erasers74413943era_sers
ermines9416673ermine_s
examiners18124433examiners
fainer94717243_fainer_
fainters11349693_fainters
fanners103914653_fanners
fawners13388493_fawners
frailer10319943frailer_
frailness1236543frailness
fraises104215693fraise_s
framers125113823fra_mers
frankers15348353frankers
fraters103517213fra_ters
friers94718933fr_i_ers
frizers19329553fr_izers
frowners14377933frowners
fruiters11328183fruiters
furriners12316323furriners
gainer74117493_gainer_
gaiters83516543_gaiters
garners83815983_garners
grabbers13337883grabbers
graders94716013gra_ders
gradines103615253gradine_s
grafters12409193grafters
grained93814273graine_d
grainier9218903grainier_
grainless1035893grainless
grains74223093grain__s
grangers103011973grangers
granters93614143granters
grapiness1238263grapiness
grapnels1134393grapnels
graspers11338403graspers
graters85419743gra_ters
gratinees10307323gratinees
gravers114515273gra_vers
grayness1235933grayness
grazers175112453gra_zers
graziers18387123graziers
grinders103410423gr_inders
grinners9288043grinners
gripers104011463gr_ipers
groaners9248503groaners
hailers104017263_hailers
imaginers1243693imaginers
ironers74813553ir_oners
jailers144114043_jailers
joiners144211573_joiners
kaisers11369273_kaisers
karabiners1642693karabiners
kraters114212343kra_ters
lanners73618333_lanners
leaners73718173lea_ners
learners8398153learners
liners65428853__liners
loaners73913623loa_ners
loriners839963loriners
mailers94420333_mailers
maimers113813043_maimers
manners93417833_manners
mariner93315993mariner_
marines93928013marine_s
meaners94415243mea_ners
miners84126633__miners
moaners92813553moa_ners
moraines10314363moraine_s
nailers73215893_nailers
obtainers1144853obtainers
orbiters1036603orbiters
ordainer945223ordainer_
ordines83014903ordine_s
orpines94414793orpine_s
painters103013023_painters
paniers94717333_paniers
panners93621273_panners
pardners11269193pardners
partners102711133partners
pawners124311073_pawners
plainer93811983plainer_
plaiters103512633plaiters
planers94517943pla_ners
planners10399933planners
praiser93413943praiser_
praises94121103praise_s
pralines102217723praline_s
prancers123210333prancers
praters94921653pra_ters
prawner1246803prawner_
prayers124212853pra_yers
preeners102712813preeners
pricers113915063pr_icers
priers84521193pr_i_ers
primers114215673pr_imers
prinkers143010383pr_inkers
printers103214903pr_inters
prizers183911843pr_izers
pruners93710723pr_uners
racers84725433_ra_cers
raciness102413453_raciness
rackers134320453_rackers
rafters103715633_rafters
raider74318743_raider_
railer64524933_railer_
rained75024603_raine_d
rainier71614263_rainier_
rainless8129703_rainless
rains55140233_rain__s
raiser66620103_raiser_
raises64826543_raise_s
rakers104123573_ra_kers
rammers113715043_rammers
ranees64623963_ra_nees
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
rapers84327183_ra_pers
rapiers95012873_rapiers
rapines95120863_rapine_s
rappers113618443_rappers
rasers64526783_ra_sers
rashers104020913_rashers
raspers94415923_raspers
rasters74629023_rasters
raters63936583_ra_ters
ratines75328583_ratine_s
ratters74422473_ratters
raveners11309133_raveners
ravers94628183_ra_vers
ravines104220233_ravine_s
rawness1038153_rawness
razers154919613_ra_zers
refiners114713313refiners
refrainers1344473refrainers
regainers10237383regainers
reinters82614773_reinters
reivers105117083_reivers
repiners103913433repiners
retainers92510763retainers
ricers84120993_r_icers
riders74123903_r_iders
rimers84522553_r_imers
ringers83922953_r_ingers
rinsers73815743_r_insers
risers64624783_r_isers
rivers94626543_r_ivers
ruiner64013643_ruiner_
runners74212453_runners
sailers73822323_sailers
scanners10379703scanners
seiners74219273_seiners
shiners104015943_shiners
spanners103710773spanners
spawners13396493spawners
stainer73614923stainer_
strainer8512223strainer_
tailers73720183_tailers
tanners74018393_tanners
tracers94917843tra_cers
trackers143512853trackers
traders84316953tra_ders
trailer73015393trailer_
trained84117203traine_d
trainee72817793traine_e
trains64725343train__s
traitors8310793traitors
trampers123210393trampers
trappers123711043trappers
trashers113013643trashers
trawlers113310203trawlers
triers64321523tr_i_ers
trimers94615143tr_imers
trines64132563tr_ine_s
twiners10459633_twiners
upraisers11174423upraisers
urines64724123ur_ine_s
vainer93714573_vainer_
vanners103612843_vanners
variers103712663vari_ers
veiners104112523_veiners
wailers103916803_wailers
waiters104218623_waiters
waivers133410053_waivers
wariness11313213wariness
warners103315563_warners
weaners104613833wea_ners
weiners103913063_weiners
whiners134011573_whiners
wrappers15306933wrappers
wringers123110073wr_ingers
writers105513493wr_iters
yarners104312203_yarners
yawners13367183_yawners
yearners11346373yearners

Search took 10 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 Limit1461624509.12616016.0
3Display Results4504500.1862419.4
 (SQL Overall)1786914509.73518355.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.