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

171 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
effuse123496(None) 
effused1434141effused
effuses1335901effuses
defuse105712722defuse
diffuse1444372diffuse
efface14366672efface
effete1235182effete
effs105114032eff_s_
effulge1442472effulge
effusive1743262effusive
excuse1537422excuse
fuse76429992__fuse
infuse93110572infuse
perfuse1247662perfuse
refuse94817512refuse
suffuse1335442suffuse
abuse77119563_abuse
accuse103411033accuse
affine12310503affine
amuse75920833_amuse
arouse65019983arouse
because1136233because
bemuse1038943bemuse
blouse84714723blouse
bouse75931853_bouse
cause75225353_cause
cayuse11207763cayuse
ceruse83914523ceruse
chouse116017563chouse
clause84311503clause
confuse1238853confuse
crouse84619363crouse
cruse75726103_cruse
defense1137503defense
deffest14308803deffest
defused125211093defused
defuser115110503defuser
defuses114814593defuses
defuze19487843defuze
delouse839833delouse
diffused1643473diffused
diffuser1543143diffuser
diffuses1534823diffuses
disuse74012833disuse
douse66329723_douse
druse64817663_druse
dufus94010813dufus_
dufuses11436593dufuses
ease45042333e__ase
ecrus75113863ecrus_
ecus65421463e_cus_
educe84313453e_duce
eff96128623eff___
effable15106673effable
effaced16225573effaced
effacer15255413effacer
effaces15277273effaces
effect1437443effect
effigy1642213effigy
efflux1942003efflux
effluxes2142453effluxes
effort1238623effort
effulged1642013effulged
effulges1542603effulges
effusing1534263effusing
effusion1444603effusion
efs66829603e_f_s_
efts76519483e_fts_
elapse857523elapse
elfish1267963elfish
else45923083e__lse
elude64517623e_lude
elute54822573e_lute
emeus76913333emeus_
emeute838533emeute
emus66821683e_mus_
encase83714363encase
endue64215353endu_e
endues73813903endues
endure74014143endure
enface112510353enface
ennuye973753ennuye
ensue54013833ensu_e
ensues63313813ensues
ensure63416003ensure
enthuse1046963enthuse
enure53520223e_nure
erase54925493e_rase
erose55727273e_rose
espouse936403espouse
etude63612303e_tude
evulse935213evulse
excise1538553excise
excused1736293excused
excuser1635813excuser
excuses1638903excuses
exhume1833803exhume
expose1549523expose
expulse1674513expulse
exude134010293e_xude
false84818123_false
fauve114712073_fauve
fease84824873_fease
ferule93413203ferule
fesse86116333_fesse
fetus85816543fetus_
fetuses10310243fetuses
feus75830753_feus_
flue75329853_flu_e
flues84626923_flues
fluke125016893_fluke
flume106021173_flume
flus75626543_flus_
flush115116073_flush
flute86823753_flute
fosse86119463_fosse
frise85322453_frise
fume96727633__fume
fused94820443__fused
fusee86224583__fusee
fusel85218493__fusel
fuses85628423__fuses
fuss76027933__fuss
fuze166422373__fuze
grouse74315023grouse
house89131423_house
incuse83513573incuse
infused11329253infused
infuser10298323infuser
infuses102711873infuses
louse56131013_louse
misuse83213643misuse
mouse77133003_mouse
muse67136033__muse
nonuse63212253nonuse
obtuse8147483obtuse
offense1343683offense
office1435693office
offish15137273offish
offs107117013off_s_
offset1238373off_set
pause75021833_pause
perfume1446503perfume
perfused1445823perfused
perfuses1358663perfuses
peruse84016843peruse
profuse1237153profuse
recluse95210773recluse
recuse85519163recuse
refuge105312613refuge
refused115114443refused
refuser104912783refuser
refuses104918553refuses
refute95515703refute
rehouse10311773rehouse
reinfuse1144783reinfuse
retuse66617223retuse
reuse56025363_reuse
rouse56634703_rouse
ruse45938933__ruse
scouse84113633scouse
souse56530773_souse
spouse84112513spouse
suffused1544023suffused
suffuses1435823suffuses
teffs115111733teff_s_
tofus86415423tofus_
touse55430673_touse
unfused11319503unfused
use36835163___use
youse85322233_youse

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161715.45320670.5
3Display Results1711710.0463717.4
 (SQL Overall)1786911715.63931688.4
 
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.