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

117 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
differed163552(None) 
niffered1544141niffered
buffered1764992buffered
coffered1737672coffered
diapered1238002diapered
dickered16117532dickered
differ133910842differ__
different1646182different
differs14339972differ_s
diffused1643492diffused
dithered13189292dithered
goffered1634522goffered
offered1436142_offered
pilfered1435852pilfered
suffered1536732suffered
bickered17108003bickered
biffed15449883biff__ed
bistered112913333bistered
bittered112711833bittered
buffeted1753733buffeted
chaffered21154483chaffered
cindered1239793cindered
ciphered1637053ciphered
coiffured1842613coiffured
dackered16116893dackered
daffed14429493daff__ed
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
deafened1335853deafened
deferred13106363deferred
deffer134411303deffer__
defleaed1344953defleaed
deflexed2043883deflexed
defueled1374513defueled
diademed1344153diademed
dieseled1035523dieseled
dieted83115493di__eted
difference1955023difference
differenced2153463differenced
differing1746483differing
diffuse1444383diffuse_
diffuser1543153diffuser
diffuses1534833diffuses
discerned1347863discerned
dispersed13119783dispersed
disserted11109813disserted
disserved14107003disserved
ditherer12187763ditherer
diverged14256883di_verged
diverted13199583di_verted
dizened18267333di_zened
doddered1234943doddered
doffed14428503doff__ed
doffer133911353doffer__
doffers14359853doffer_s
donnered10307753donnered
dormered1255673dormered
dowered122811553d_owered
duffer134711663duffer__
duffers143410093duffer_s
fibered1337643fi_bered
filtered12259043filtered
fingered13128333fingered
gauffered1741873gauffered
gibbered1444303gibbered
gingered11127743gingered
hindered1339453hindered
inferred12248353_inferred
inhered11313163_inhered
jiggered1834203jiggered
jittered16267223jittered
kippered17255623kippered
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
littered92511383littered
livered113111633li_vered
miffed15398713miff__ed
misfeed13389683misfe_ed
misfired14238543misfired
mitered103213233mi_tered
mufflered1842123mufflered
nickered15117023nickered
niffer12378443niffer__
niffers13287363niffer_s
offerer1335543_offerer
piffled16366403piff_led
pilferer1344923pilferer
proffered1843433proffered
raftered1237673raftered
reoffered1643313reoffered
riffed133811563riff__ed
riffled14338603riff_led
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sintered92213903sintered
sistered92612803sistered
stiffened1642133stiffened
sufferer1436063sufferer
tafferel1443123tafferel
telfered1234883telfered
tiered73613973ti__ered
tiffed13368393tiff__ed
tiffined1543403tiffined
tillered937443tillered
timbered13137383timbered
tinkered1387683tinkered
tittered9239493tittered
unoffered1643363unoffered
wafered14288433_wafered
wildered1336633wildered
wintered122111573wintered
withered15169433withered
zippered22244823zippered

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.466383457.1
2DLD Change Limit1461621177.20320291.8
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.71523161.5
 
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.