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 “diffuse” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
diffuse144437(None) 
diffused1643481diffused
diffuser1543141diffuser
diffuses1534821diffuses
defuse105712722d_efuse
diffs126315482diff_s_
diffusely1952022diffusely
diffusers1642772diffusers
diffusive1952742diffusive
diffusor1541902diffusor
diseuse83110722diseuse
disuse74012842di_suse
effuse1234962_effuse
infuse93110572_infuse
suffuse1335442suffuse
biffies152710853biffies
biffs134814413biff_s_
coiffeuse1741613coiffeuse
coiffure1643123coiffure
confuse1238853confuse
daffs125116423daff_s_
defense1137503defense
deffest14308803deffest
defused125211093d_efused
defuser115110503d_efuser
defuses114814593d_efuses
defuze19487843d_efuze
delouse839833delouse
diabase1037113diabase
dialyse1135463dialyse
diapause1143893diapause
diff116228843diff___
differ133910843diff_er
differed1635523differed
differs14339973differs
diffusible1952353diffusible
diffusing1743853diffusing
diffusion1643973diffusion
diffusors1651833diffusors
difs86027323di_f_s_
dilute72911803di_lute
dingus83611843dingus_
dinguses1037643dinguses
diocese1036853diocese
diphase1387273diphase
disabuse1145553disabuse
disburse1186443disburse
discase102912863discase
discus94512113discus_
discuses113112863discuses
discuss10357953discuss
disease83213843disease
diseuses93112763diseuses
disguise1046833disguise
disgust937633disgust
dispose10312763dispose
dispute1039083dispute
disused93211033di_sused
disuses84015413di_suses
diverse11429993diverse
divulse1134913divulse
doffs125614333doff_s_
doofus1036163doofus_
doofuses1244283doofuses
douse66329723d__ouse
druse64817663d__ruse
duffle13368533duff_le
duffles14308923duffles
duffs125216623duff_s_
dufus94010813d_ufus_
dufuses11436593d_ufuses
effused1434143_effused
effuses1335903_effuses
fuse76429993___fuse
incuse83513573_incuse
infused11329253_infused
infuser10298323_infuser
infuses102711873_infuses
jiffies20327473jiffies
jiffs185710313jiff_s_
miffs134512883miff_s_
misuse83213643mi_suse
perfuse1247663perfuse
piffle14418233piff_le
piffles15368763piffles
profuse1237153profuse
refuse94817513_refuse
reinfuse1144783reinfuse
riffle124210233riff_le
riffles133911163riffles
riffs115114613riff_s_
suffused1544023suffused
suffuses1435833suffuses
tiffs114414883tiff_s_

Search took 7 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 Filter1786911340270.1401276364.3
2DLD Change Limit134027945.92022639.7
3Display Results94940.0462043.5
 (SQL Overall)178691946.10629264.8
 
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.