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

221 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
defusers1248736(None) 
defuser115110501defuser_
defuses114814591defuse_s
refusers11499271refusers
debasers11377902debasers
defacers14237992defacers
defamers14258522defamers
defers105116942def__ers
defiers113913992def_iers
defilers12439472defilers
definers124211192definers
defuels11296982defu_els
defuse105712722defuse__
defused125211092defuse_d
defuzes20398302defuze_s
delousers1044662delousers
deluders10156432deluders
delusters1035982delusters
denuders10165872denuders
deposers11359242deposers
devisers12339862devisers
diffusers1642772diffusers
dousers84817272d_ousers
dufuses11436592dufuse_s
infusers11286142infusers
perusers10328802perusers
refuser104912782refuser_
refuses104918552refuse_s
refuters11449612refuters
abusers94710553_abusers
accusers12285903accusers
amusers94610193_amusers
arousers84810983arousers
befoulers1443123befoulers
bemuses1139293bemuse_s
causers94014793_causers
censers94313903ce_nsers
ceruses93716233ceruse_s
chousers134610203chousers
daubers104610423d_aubers
dealers84118613de_alers
debaser103510413debaser_
debases103814133debase_s
debaters113511923debaters
deboners11268113deboners
debuggers1442713debuggers
debunkers1642703debunkers
decayers14307963decayers
deciders123510753deciders
deckers144413833de_ckers
decoders122810413decoders
decoyers14287713decoyers
decreers11277623decreers
decriers11299733decriers
deduces1168793deduce_s
deemsters1285023deemsters
deers64930523de___ers
defacer132810363defacer_
defaces133213403deface_s
defamer132710323defamer_
defames132812253defame_s
defaulters1442383defaulters
defeaters13289103defeaters
defenders1436363defenders
defenses1237913defense_s
defer94619753def__er_
deferrers13115153deferrers
deffer134411303def_fer_
defier105118653def_ier_
defies104624053def_ie_s
defiler113911883defiler_
defiles114016843defile_s
definer114413773definer_
defines114118683define_s
deflaters13298703deflaters
defleas1147223def_leas
deflowers16145643deflowers
defoamers15285253defoamers
defocuses15134493defocuse_s
defoggers1543053defoggers
deforcers15265503deforcers
deformers15266533deformers
defrauders1541993defrauders
defrayers1644173defrayers
defrosters1443363defrosters
defter104215923def_ter_
deftness1236303deftness
defuel10348933defu_e_l
defunds12376753defu_nds
defusing13227933defusing
defuze19487843defuze__
defuzed21447043defuze_d
degases93413103degase_s
degassers11354833degassers
degaussers1241663degaussers
degusts936063degus_ts
deicers103612733de_icers
deifiers12348993deifiers
dejeuners1742443dejeuners
delayers12268663delayers
delivers123310753delivers
delouser936363delouser_
delouses9310013delouse_s
deluder9168333deluder_
deludes91810643delude_s
deluges9169263deluge_s
delusory1273003delusory
deluster936903deluster_
delvers113411993de_lvers
demises103719563demise_s
demisters1249203demisters
demoses103815823demose_s
dempsters1435273dempsters
demurer1037873demurer_
demurrers1243713demurrers
demurs939773demu__rs
deniers84515183de_niers
denser74115193de_nser_
denuder9167603denuder_
denudes91510043denude_s
deposer104011843deposer_
deposes103117213depose_s
deputes104911783depute_s
deriders102411853deriders
derivers123811363derivers
desert72725493de__sert
deserts82513053de__serts
desirers939263desirers
despisers1245153despisers
dessert82916453de_ssert
desserts9247923de_sserts
desugars1043373desugars
deters74724683de__ters
detesters10298303detesters
deuces94015513de_uce_s
devisees12358283devisees
deviser114212393deviser_
devises114116763devise_s
devisors12347253devisors
devourers1344093devourers
dewaters122910723dewaters
differs14339973dif_fers
diffuser1543143diffuser_
diffuses1534823diffuse_s
diffusors1651833diffusors
diluters9288113diluters
disuses84015413disuse_s
doffers14359853dof_fers
doofuses1244283doofuse_s
dorsers83516303d_orsers
dosers75723633d__osers
dossers84516233d_ossers
douser75621633d_ouser_
douses74928933d_ouse_s
dowsers115013533d_owsers
dressers9359863dressers
druses75517253d_ruse_s
duffers143410093duf_fers
dupers94615603d__upers
dusters84918363d__usters
effuses1335903effuse_s
eluders8409903_eluders
erasers74413943_erasers
excusers1734443excusers
fetuses10310243fetuse_s
focusers13134373focusers
fumers113613383__fumers
fusees95416403__fusees
fusels94412453__fusels
fuses85628423__fuse_s
fussers104210813__fussers
genuses83510883genuse_s
geysers1135703ge_ysers
grousers93810733grousers
hefters134312003hef_ters
housers104717813_housers
infuser10298323infuser_
infuses102711873infuse_s
leasers74717843le_asers
misusers10348083misusers
mousers95216443_mousers
musers84719103__musers
neguses837933neguse_s
neuters74212273ne_uters
nexuses1436743nexuse_s
nonusers8268003nonusers
pausers94113223_pausers
perfumers1683713perfumers
perfuses1358663perfuse_s
peruser93511373peruser_
peruses94018163peruse_s
rebukers14435683rebukers
rebuses94915293rebuse_s
recuses94619463recuse_s
reducers1147263reducers
refers93921083ref__ers
refiners114713313refiners
refuels10399523refu_els
refugees12476403refugees
refuges115413373refuge_s
refunders1334973refunders
refusals1164913refusals
refuse94817513refuse__
refused115114443refuse_d
refuter104312193refuter_
refutes104515733refute_s
reposers102911603reposers
repulsers1144713repulsers
resumers1038083resumers
reuses66025523re_use_s
revisers113511933revisers
rousers75220143_rousers
securers1057153securers
seducers1145383seducers
seisers73816393se_isers
teasers75317243te_asers
trousers83910633trousers
users55817573___users
venuses103111413venuse_s
versers103813523ve_rsers
xeruses143010753xeruse_s

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.406440125.6
2DLD Change Limit1461622216.53322372.9
3Display Results2212210.0762907.9
 (SQL Overall)1786912217.01525472.7
 
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.