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

76 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
dieoffs144303(None) 
dieoff1335501dieoff_
diffs126315482di__ffs
doffs125614332d__offs
feoffs1163702_feoffs
ripoffs1543382ripoffs
tipoffs1543032tipoffs
biffs134814413bi__ffs
boffs134915503__boffs
boiloffs1641983boiloffs
buyoffs1842433buyoffs
coffs134916303__coffs
cutoffs1533603cutoffs
daffs125116423d__affs
decafs124010883d_ecafs
defis96717503d_e_fis
defogs1156683d_efogs
delfs94918673d_e_lfs
delfts10439673d_elfts
dicots94915793dico_ts
didoes85716963dido_es
didos76820813dido__s
dienes75719903die_nes
dies55653523die___s
diesels8429143diesels
dieses75218693die_ses
diesis74013493die_sis
dieters83216433dieters
diets66026643die__ts
diff116228843di__ff_
difs86027323di___fs
dimouts1037893dimouts
dinos65428063dino__s
diodes83915783di_odes
diols65521013di_o_ls
dipoles101013753dipoles
disowns1136733disowns
distaffs1565083distaffs
divots104712203divo_ts
doff116225783d__off_
doofus1036163d_oofus
draffs13617903d_raffs
duffs125216623d__uffs
dustoffs1543163dustoffs
effs105114033__e_ffs
enfeoffs1361823enfeoffs
feoff10711053_feoff_
fiefs116213703fie__fs
flyoffs1542253flyoffs
infeoffs1352083infeoffs
jiffs185710313ji__ffs
kickoffs1941743kickoffs
kiefs126112203kie__fs
layoffs1642573layoffs
liftoffs1342063liftoffs
miffs134512883mi__ffs
offs107117013___offs
payoffs1843243payoffs
pickoffs2242373pickoffs
pilaffs15365153pilaffs
putoffs1543333putoffs
rakeoffs1842203rakeoffs
riffs115114613ri__ffs
ripoff1436433ripoff_
ruboffs1543123ruboffs
runoffs1343013runoffs
scoffs14347503_scoffs
setoffs1334133setoffs
shroffs1634363shroffs
spinoffs1642773spinoffs
takeoffs1842323takeoffs
teffs115111733_te_ffs
tiffs114414883ti__ffs
tipoff1436383tipoff_
toffs116016723__toffs
waveoffs2042043waveoffs

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 Filter1786911340270.390458182.1
2DLD Change Limit134027766.79619721.5
3Display Results76760.0164750.0
 (SQL Overall)178691767.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.