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

337 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
definers12421119(None) 
defiers113913991defi_ers
defilers12439471defilers
definer114413771definer_
defines114118681define_s
refiners114713311refiners
befingers1544102befingers
deboners11268112deboners
deciders123510752deciders
decliners12358612decliners
defacers14237992defacers
defamers14258522defamers
defenders1436362defenders
defers105116942def__ers
defier105118652defi_er_
defies104624052defi_e_s
defiler113911882defiler_
defiles114016842defile_s
define104718142define__
defined123813822define_d
definiens1345302definiens
deftness1236302deftness
defusers12487362defusers
deicers103612732de_icers
deifiers12348992deifiers
delivers123310752delivers
deniers84515182deni_ers
deriders102411852deriders
deringers1137182deringers
derivers123811362derivers
designers1136002designers
desirers939262desirers
detainers10269102detainers
devisers12339862devisers
dewiness1238452dewiness
diners75525952d__iners
diviners12308352diviners
drainers92811252drainers
refiner105316912refiner_
refinery14447192refinery
refines105426342refine_s
repiners103913432repiners
seiners74219272se_iners
veiners104112522ve_iners
weiners103913062we_iners
adenines9310193adenine_s
affines1339483affine_s
affixers2143293affixers
aliners74717723_aliners
beefiness1435583beefiness
befinger1434643befinger_
beginners1283613beginners
beliers94617383beli_ers
biners85023633__biners
briners94315633_briners
byliners1334753byliners
ceilers93912533ce_ilers
centners1057243centners
coiners93620753_coiners
confiners1439953confiners
daffiness1634843daffiness
daftness1235533daftness
daikers124010313d_aikers
damners104112113d_amners
darners83815773d_arners
deadeners1146283deadeners
deadness1039233deadness
deafness1236213deafness
deairs74013783deai__rs
dealers84118613de_alers
deanery1137613de_anery
dearness939973dearness
debasers11377903debasers
debaters113511923debaters
deboner103110483deboner_
debones103315113debone_s
debunkers1642703debunkers
decanes103118913decane_s
decanters12229223decanters
decayers14307963decayers
deceivers1535723deceivers
decenters122410373decenters
deciares11510633deciares
decibels1344523decibels
decider114213183decider_
decides114217653decide_s
deciles104417723decile_s
deciphers1744393deciphers
deckers144413833de_ckers
decliner113710843decliner_
declines113315803decline_s
decoders122810413decoders
decoyers14287713decoyers
decreers11277623decreers
decriers11299733decriers
deepeners1244523deepeners
deepness1136443deepness
deers64930523de___ers
defacer132810363defacer_
defaces133213403deface_s
defamer132710323defamer_
defames132812253defame_s
defangs1235363defan_gs
defeaters13289103defeaters
defences1439633defences
defender1337293defender_
defends12358773defen_ds
defenses1237913defenses
defer94619753def__er_
deferrers13115153deferrers
deffer134411303def_fer_
defiances1557033defiances
deficits1447273deficits
defied115016383defi_e_d
defile105216663defile__
defiled124013103defile_d
defining133711803defining
definite1239323definite
defis96717503defi___s
deflaters13298703deflaters
defleas1147223def_leas
deflowers16145643deflowers
defoamers15285253defoamers
defoggers1543053defoggers
deforcers15265503deforcers
deformers15266533deformers
defrayers1644173defrayers
defter104215923def_ter_
defuels11296983def_uels
defunds12376753defun_ds
defuser115110503defuser_
defuses114814593defuse_s
defuzes20398303defuze_s
degenders1236083degenders
dehorners1344743dehorners
deicer94114413de_icer_
deices94119373de_ice_s
deifier113013123deifier_
deifies113317453deifie_s
dejeuners1742443dejeuners
delaines9312963delaine_s
delayers12268663delayers
delimes10314193delime_s
deliver113312243deliver_
delivery15286553delivery
deluders10156433deluders
delvers113411993de_lvers
demanders13247573demanders
demies94825803demi_e_s
demireps1343993demireps
demises103719563demise_s
demisters1249203demisters
demoness1138053demoness
denars74621433de__nars
denes65639723de__ne_s
denier74420693deni_er_
denies74729643deni_e_s
denizens1835573denizens
dentines93418403dentine_s
denuders10165873denuders
depicters1435823depicters
depones103717093depone_s
deposers11359243deposers
deprivers1545213deprivers
derangers1136703derangers
derider93214973derider_
derides93420853deride_s
deringer1038143deringer_
deriver114213913deriver_
derives114017813derive_s
dernier83011943dernier_
derringers1243843derringers
designees1145003designees
designer1036543designer_
desilvers13306083desilvers
desinent9312963desinent
desirer8310783desirer_
desires81316133desire_s
despisers1245153despisers
destines93619663destine_s
detailers10257253detailers
detainees10267153detainees
detainer92910793detainer_
deters74724683de__ters
detickers1634423detickers
detinues9569823detinues
devices133212583device_s
devisees12358283devisees
deviser114212393deviser_
devises114116763devise_s
devisors12347253devisors
dewaters122910723dewaters
dewier104013463dewi_er_
dexies145018343dexi_e_s
dezincs1933753dezin_cs
dicers94720743d__icers
diesinkers1552783diesinkers
differs14339973dif_fers
dikers114418793d__ikers
dimers94321093d__imers
dinars75417563d__inars
diner65632903d__iner_
dinero75612643d__inero
dineros83812333d__ineros
dines66449153d__ine_s
dingers94321383d__ingers
dinners83915443d_inners
disinters1039713disinters
divers105024963d__ivers
dividers13257213dividers
diviner11369883diviner_
divines113514723divine_s
doffers14359853dof_fers
domineers1244673domineers
domines102918973domine_s
dopiness11289973dopiness
downers113912773d_owners
doziness18228553doziness
drainer83012843drainer_
driers74516733d_ri_ers
drifters12417913drifters
drinkers13277823d_rinkers
drivers114412793d_rivers
droners84114383d_roners
drowners12428273drowners
duffers143410093duf_fers
duikers12369383d_uikers
dwines105013103d_wine_s
earners74016453_earners
edginess1036053edginess
edifiers12336673edifiers
eeriness8311873eeriness
eiders74321363_e_iders
eloiners8128153eloiners
epimers11109493_epimers
eveners10109503_eveners
exilers14419733_exilers
exines135715803_exine_s
eyeliners1264063eyeliners
feigners1235483feigners
felines104718073feline_s
fibers114717523__fibers
fifers125414923__fifers
filers94623723__filers
finders113717873__finders
finer85431563__finer_
finery124512893__finery
fines86644263__fine_s
fingers113418433__fingers
firers94922683__firers
fivers124420923__fivers
fixers165112983__fixers
gainers84214593_gainers
grainers93012073grainers
hefters134312003hef_ters
heftiness1536313heftiness
heifers1337933he_ifers
iffiness1435023iffiness
jetliners1644183jetliners
joiners144211573_joiners
keeners113610783ke_eners
kefirs13396653kefi__rs
leafiness1236483leafiness
leaners73718173le_aners
learners8398153learners
leviers103510343levi_ers
liners65428853__liners
loriners839963loriners
mariners103113863mariners
meaners94415243me_aners
metiers93312843meti_ers
miners84126633__miners
officers1643803officers
olefines1137323olefine_s
penners93414183pe_nners
reciters102613113reciters
recliners11279113recliners
redefines1347413redefine_s
redliners10267853redliners
refers93921083ref__ers
refiles104122423refile_s
refilters1236103refilters
refinds114512123refin_ds
refine95225693refine__
refined114720003refine_d
refineries1347063refineries
refires104820313refire_s
refixes174813173refixe_s
refrainers1344473refrainers
refunders1334973refunders
refusers11499273refusers
refuters11449613refuters
regainers10237383regainers
reifiers11309843reifiers
reinters82614773re_inters
reivers105117083re_ivers
reliers75519213reli_ers
relines75331323reline_s
reminders12308653reminders
repiner94816903repiner_
repines94927383repine_s
residers93311883residers
resigners1036863resigners
retainers92510763retainers
retines75134673retine_s
retirers84311533retirers
revilers114011693revilers
revisers113511933revisers
revivers14389633revivers
rewinders13246503rewinders
rexines144719153rexine_s
ruiners74213023_ruiners
seiner64622483se_iner_
seines65029903se_ine_s
seisers73816393se_isers
seizers164112503se_izers
seminars1079043seminars
serines74229543serine_s
sexiness1537943sexiness
shiners104015943_shiners
sideliners11125133sideliners
stainers83212173stainers
teeners74415453te_eners
tenners74014923te_nners
tenoners858713tenoners
trainers83114643trainers
twiners10459633_twiners
veilers103911823ve_ilers
veiner94514753ve_iner_
veligers1237023veligers
venines103516613venine_s
verniers11227843verniers
vetivers1435163vetivers
weaners104613833we_aners
weiner94214133we_iner_
whiners134011573_whiners
yearners11346373yearners

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.1561145455.1
2DLD Change Limit1461623377.04620744.0
3Display Results3373370.1432356.6
 (SQL Overall)1786913377.34524328.3
 
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.