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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
defat9542669(None) 
defats105114551defats
defeat103817161defeat
deft85540221def_t
derat65044081derat
beat66168302be_at
befit105222662befit
begat86629722begat
daft85537252daf_t
dead65434242de_ad
deaf85838402de_af
deal56347412de_al
dealt65234282dealt
dean56039482de_an
dear55343602de_ar
death94822522de_ath
debag94212302debag
debar85517862debar
debate94419192debate
debit85727852debit
debt77139022de_bt
debut86024142debut
decaf114919442decaf
decal85523232decal
decant93524222decant
decay114718482decay
dedal75719022dedal
deet57356582de_et
def76546722def__
deface123113862deface
defame123212432defame
defang1137752defang
default1147892default
defeats113511232defeats
defect124816172defect
defer94619752defer
defi86321492def_i
defiant11311922defiant
defis96717502defis
deflate113613942deflate
defoam1238562defoam
defog1048522defog
defrag1136462defrag
defray1337642defray
defy114921262def_y
degas75119162degas
deist64633592deist
delate73827752delate
delay94820632delay
delft95623322delft
delt57855272de_lt
delta66117772delta
demast9517062demast
demit84832302demit
denar65223292denar
dent57158412de_nt
depart94720562depart
depot85727922depot
derate74531232derate
derats74625062derats
deray95024182deray
desalt7518312desalt
deva85720982deva_
devas96218882devas
dewan95718042dewan
dewar95817732dewar
dewax165510852dewax
doat56947672d_oat
draft95526682draft
drat56247832d_rat
ducat86225902ducat
eat36989052_e_at
eft66038822_ef_t
fat68178082__fat
feat76458222fe_at
heat77061422he_at
heft106736292hef_t
left76340482lef_t
meat66359602me_at
neat46356782ne_at
peat65967932pe_at
refit84230062refit
reft75141272ref_t
resat55139682resat
seat47575562se_at
teat45963632te_at
weft105435012wef_t

Search took 5 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.640279204.7
2DLD Change Limit53800873.45315580.7
3Display Results87870.0461891.3
 (SQL Overall)178691874.13943172.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.