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

104 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
effusing153426(None) 
defusing13227932defusing
diffusing1743852diffusing
effacing1744462effacing
effulging1742152effulging
effusion1444602effusion
effusions1544372effusions
effusive1743262effusive
excusing1836502excusing
fusing104415952__fusing
infusing1237892infusing
perfusing1565632perfusing
refusing122310872refusing
suffusing1643532suffusing
abusing1049113_abusing
accusing1336783accusing
affixing2264333affixing
affusion1443923affusion
affusions1543623affusions
amusing1039383_amusing
arousing93811803arousing
befouling1534983befouling
bemusing1336613bemusing
blousing1138793blousing
bousing103718043_bousing
busing96420593__busing
causing103614413_causing
censusing1244813censusing
chousing14259423chousing
confusing1537333confusing
defensing14217003defensing
defocusing1752813defocusing
defuzing22195253defuzing
delousing1136303delousing
disusing1039003disusing
dousing93315763_dousing
easing74926463e__asing
educing1137683e_ducing
effecting1845583effecting
effuse1234963effus__e
effused1434143effus_ed
effuses1335903effus_es
elapsing1146713elapsing
eluding93412113e_luding
eluting84115293e_luting
encasing11610823encasing
enduing9249723endu_ing
enduring10310013enduring
enfacing1467293enfacing
ensuing8239543ensu_ing
ensuring9310173ensuring
enthusing1355213enthusing
enuring8813883e_nuring
erasing8317963e_rasing
espousing1265003espousing
evulsing1234733evulsing
excising1837213excising
exhuming2143303exhuming
exposing1836673exposing
expulsing1944283expulsing
exuding16347443e_xuding
feasing113916653_feasing
feruling1258873feruling
fessing113812863_fessing
feuding123410263_feuding
feuing104412273_feu_ing
fluking154410513_fluking
fluming133512793_fluming
flushing15288833_flushing
fluting113815093_fluting
fluxing18398923_fluxing
focusing1436603focusing
fouling113315373_fouling
fuming124013293__fuming
fussing113611683_fussing
fuzing194110643__fuzing
grousing103410453grousing
hocusing1446583hocusing
housing113316523_housing
incusing1159953incusing
lousing83817733_lousing
misusing1138893misusing
mousing103816273_mousing
musing93919503__musing
nonusing939233nonusing
offering1536393offering
offing13368643off__ing
pausing103912813_pausing
perfuming1784053perfuming
perusing11811063perusing
recusing112512883recusing
reffing143712173reff__ing
refluxing2034583refluxing
refocusing1653853refocusing
refuging13218423refuging
refuting121911903refuting
rehousing1337253rehousing
reinfusing1443613reinfusing
reusing82516783_reusing
rousing83920553_rousing
sousing83517823_sousing
spousing11198733spousing
tousing82916993_tousing
using66317963___using

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621046.70321805.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.92225814.9
 
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.