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 “defis” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
defis9671750(None) 
defi86321491defi_
defies104624051defies
delis64928541delis
aegis6316782aegis
befit105222662befit
befits114711502befits
cedis84317082cedis
daffs125116422daffs
dais57040702d_ais
deads75726912deads
deafish1438532deafish
deair65817192deair
deairs74013782deairs
deals65435342deals
deans66131392deans
dears65736882dears
debit85727852debit
debits94214502debits
debris93311492debris
debs76530242de_bs
debts86418372debts
decks124822192decks
decos85522122decos
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deets65330242deets
def76546722def__
defat95426692defat
defats105114552defats
defer94619752defer
defers105116942defers
defied115016382defied
defier105118652defier
defiers113913992defiers
defile105216662defile
defiles114016842defiles
define104718142define
defines114118682defines
defog1048522defog
defogs1156682defogs
deft85540222def_t
defuse105712722defuse
defy114921262def_y
degas75119162degas
deific1237312deific
deifies113317452deifies
deify124112762deify
deil56231622de_il
deils65722862deils
deism84116032de_ism
deist64633592de_ist
deixis1437242deixis
dekes105224452dekes
deles65139252deles
delfs94918672delfs
delfts10439672delfts
deli55631292deli_
delish105215612delish
delist74625052delist
dells66630942dells
dels56745472de_ls
delts65731792delts
demes86032692demes
demic105119192demic
demies94825802demies
demise94618322demise
demit84832302demit
demits94918072demits
demos86022992demos
denes65639722denes
deni56929392deni_
denies74729642denies
denim85518842denim
denims95214322denims
dens55945072de_ns
dents65031802dents
dermis94717162dermis
derms85022892derms
derris73615272derris
desist74818812desist
desks105913072desks
devas96218882devas
devil94714732devil
devils104412812devils
devise104215752devise
devs86424032de_vs
dews86230602de_ws
dexes135224512dexes
dexie134716892dexie
dexies145018342dexies
deys85027472de_ys
diesis74013492diesis
diffs126315482diffs
difs86027322dif_s
dis46459892d__is
doffs125614332doffs
duffs125216622duffs
dufus94010812dufus
effs105114032_effs
efs66829602_ef_s
efts76519482_efts
egis56520652_egis
hefts116218152hefts
jefes155613672jefes
kefir12457912kefir
kefirs13396652kefirs
kefs115922742kef_s
kepis115313362kepis
kufis1249252kufis
lefts86517812lefts
leis45739602le_is
lenis56326862lenis
levis85818552levis
lewis85315842lewis
lexis125916032lexis
metis75025902metis
neifs85613042neifs
penis75129322penis
peris75537072peris
refit84230062refit
refits94017652refits
refix155212482refix
refs75732242ref_s
reifs84819092reifs
reis45343232re_is
seifs85019332seifs
seis45542392se_is
semis74623532semis
teffs115111732teffs
wefts116715492wefts
yetis85418392yetis

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001351.37639098.8
3Display Results1351350.0462934.8
 (SQL Overall)1786911351.735102991.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.