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

101 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
dieoff133550(None) 
dieoffs1443031dieoffs
diff116228842di__ff
doff116225782d__off
feoff10711052_feoff
ripoff1436432ripoff
tipoff1436382tipoff
biff125026893bi__ff
boff124727333__boff
boiloff1543783boiloff
buyoff1754233buyoff
coff126930783__coff
cutoff1436563cutoff
daff115229683d__aff
deaf85838403d_e_af
decaf114919443d_ecaf
def76546723d_e__f
defi86321493d_e_fi
defog1048523d_efog
deft85540223d_e_ft
defy114921263d_e_fy
deify124112763d_eify
delf85436573d_e_lf
delfs94918673d_elfs
delft95623323d_elft
deoxy1648883d_eoxy
dicot85429093dico_t
dicots94915793dicots
dido66528203dido__
didoes85716963didoes
didos76820813dido_s
die46759653die___
died66137853die__d
dieing84018653dieing
diel59034603die__l
diene65720133die_ne
dienes75719903dienes
dies55653523die__s
diesel74410403diesel
dieses75218693dieses
diesis74013493diesis
diet57357533die__t
dieted83115493dieted
dieter73516773dieter
diets66026643die_ts
dif76846903di___f
diffs126315483di_ffs
difs86027323di__fs
dimout9414243dimout
dino56036753dino__
dinos65428063dino_s
diode74716113di_ode
dioecy1235543dioecy
diol57329133di_o_l
diols65521013di_ols
dipody1336363dipody
dipole91112853dipole
disown1036953disown
distaff1467683distaff
divot95723073divo_t
divots104712203divots
doffs125614333d__offs
draff125615663d_raff
duff114326643d__uff
dustoff1445053dustoff
eff96128623__e_ff
enfeoff1272793enfeoff
feoffs1163703_feoffs
fief107331363fie__f
fiefs116213703fie_fs
flyoff1444023flyoff
iff96730393_i__ff
infeoff1253263infeoff
jiff175321413ji__ff
kickoff1843013kickoff
kief117128413kie__f
kiefs126112203kie_fs
layoff1545093layoff
lief76036993lie__f
liftoff1243163liftoff
miff125625063mi__ff
off96331633___off
payoff1736023payoff
pickoff2143693pickoff
pilaff143910363pilaff
putoff1436423putoff
rakeoff1743463rakeoff
riff104430103ri__ff
ripoffs1543383ripoffs
ruboff1435203ruboff
runoff1235413runoff
scoff134413343_scoff
setoff1238913setoff
shroff1538503shroff
spinoff1544933spinoff
takeoff1743883takeoff
teff106023763_te_ff
tiff104727723ti__ff
tipoffs1543033tipoffs
toff105929903__toff
waveoff1942823waveoff

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.406440125.6
2DLD Change Limit1127161015.50320482.6
3Display Results1011010.0303366.7
 (SQL Overall)1786911015.93930087.7
 
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.