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

57 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
diffusing174385(None) 
defusing13227932d_efusing
differing1746472differing
diffusion1643972diffusion
diffusions1743732diffusions
diffusive1952742diffusive
disusing1039002di_susing
effusing1534262_effusing
infusing1237892_infusing
suffusing1643532suffusing
biffing163510013biff__ing
coiffuring1942573coiffuring
confusing1537333confusing
daffing15369733daff__ing
defensing14217003defensing
defocusing1752813defocusing
defuzing22195253d_efuzing
delousing1136303delousing
dialysing1444483dialysing
diapausing1442873diapausing
diffuse1444373diffus__e
diffused1643483diffus_ed
diffusely1952023diffusely
diffuser1543143diffus_er
diffusers1642773diffusers
diffuses1534823diffus_es
diffusible1952353diffusible
diffusional1852233diffusional
diffusor1541903diffus_or
diffusors1651833diffusors
diluting10248983di_luting
disabusing1444613disabusing
disbursing1445373disbursing
discasing1339433discasing
discussing1445983discussing
diseasing11310833diseasing
disguising1346013disguising
disgusting1345963disgusting
disposing1339933disposing
disputing1337763disputing
dissing94517683di__ssing
divulsing14103933divulsing
doffing15357793doff__ing
dousing93315763d__ousing
fusing104415953___fusing
incusing1159953_incusing
miffing16298403miff__ing
misusing1138893mi_susing
niffering1645133niffering
perfusing1565633perfusing
piffling1745133piff_ling
refusing122310873_refusing
reinfusing1443613reinfusing
riffing144011273riff__ing
riffling1556113riff_ling
tiffing14339383tiff__ing
tiffining1642913tiffining

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641577.01621186.0
3Display Results57570.0301900.0
 (SQL Overall)178691577.20224811.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.