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

229 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
defatted133567(None) 
deratted1048401deratted
befitted14305722befitted
debated113916082deba_ted
decanted122310492decanted
defaced142910972defa_ced
defamed14309832defa_med
defanged1435432defanged
defaulted1443312defaulted
defeated132812162defeated
defected15289972defected
deflated133412302deflated
delated93722872dela_ted
demasted1238762demasted
demitted12288772demitted
dentated10411702dentated
departed1238822departed
derated93623502dera_ted
desalted1038312desalted
dratted9358592d_ratted
fatted105419842__fatted
refitted12309412refitted
aerated85322373aera_ted
batted95623653__batted
bedotted1234983bedotted
befretted1544373befretted
belated103520013bela_ted
berated104422133bera_ted
besotted1135843besotted
betatter1035453betatter
betted94721163be__tted
blatted104812713_blatted
catted95422473__catted
cerated103922473cera_ted
chatted133411893_chatted
darted84620923d__arted
dated75530993d__a_ted
dauted84114933d__auted
dawted11489683d__awted
deafened1335853deafened
deaired9411533de_aired
dealated103213603dealated
deaned84620453de_a_ned
deashed123411303de_ashed
deathbed1543393de_athbed
deaved114916553de_a_ved
debagged1433723debagged
debarked16175823debarked
debarred12165633debarred
debased113310583deba_sed
debate94419193deba_te_
debater104114693deba_ter
debates103718533deba_tes
debited113311623de_bited
debuted11379333de_buted
decamped1634963decamped
decanter112510793decanter
decayed14309333deca_yed
decocted1437683decocted
deducted1356243deducted
deface123113863defa_ce_
defacer132810363defa_cer
defaces133213403defa_ces
defalcated1744183defalcated
defame123212433defa_me_
defamer132710323defa_mer
defames132812253defa_mes
defat95426693defa_t__
defats105114553defa_t_s
defatting1436103defatting
defaulter1343133defaulter
defeater122611663defeater
defecated1637493defecated
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferred13106363deferred
defied115016383def__ied
defiled124013103def_iled
defined123813823def_ined
deflate113613943deflate_
deflater123211603deflater
deflates123013943deflates
defleaed1344943defleaed
deflected1635983deflected
deflexed2043873deflexed
defoamed15356243defoamed
defogged1533783defogged
deforced15247373deforced
deformed15248263deformed
defragged1643043defragged
defrauded1542823defrauded
defrayed1635403defrayed
defrosted1444253defrosted
defter104215923def__ter
defueled1374513defueled
defunded1435163defunded
defused125211093def_used
defuzed21447043def_uzed
degassed11275963degassed
degusted1135733degusted
dehorted1357303dehorted
dejected19307593dejected
delate73827753dela_te_
delates83526283dela_tes
delayed123310763dela_yed
deleted93314903de_leted
delisted10310563delisted
demanded13348513demanded
demarked16187223demarked
demented12311273demented
demoted114313543de_moted
denatured1146023denatured
denoted93512763de_noted
dentate8315153dentate_
dented84120513de__nted
depainted1375843depainted
departee1139723departee
depicted1437743depicted
depleted12258713depleted
deported1249703deported
deputed114610173de_puted
derailed102410403derailed
deranged1137693deranged
derate74531233dera_te_
derates84028893dera_tes
desalter938363desalter
desanded11227453desanded
descanted1336673descanted
deserted101012203deserted
desisted1039783desisted
despited1248323despited
detached1537733detached
detailed10319873detailed
detained103111643detained
detected12289733detected
detested10279623detested
detracted1357793detracted
devalued1335013devalued
devastated1544123devastated
devested13239133devested
deviated13311043deviated
devoted124111093de_voted
dewater112912423dewa_ter
dewatered1444743dewatered
dewaxed19316053dewa_xed
dictated1239203dictated
dilated93115823dila_ted
doated84118183d_oa_ted
donated93513863dona_ted
dotted84717523d__otted
drafted12439033d_rafted
duetted937023d_uetted
elated74725823_ela_ted
emitted103010853_emitted
enacted10310643_enacted
estated83715573_estated
exacted1737303_exacted
exalted1537393_exalted
exapted1736073_exapted
farted105121783__farted
fasted105320953__fasted
fated95632133__fa_ted
fatten94314903__fatten
fatter94523213__fatter
feasted11310843fe_asted
fetted104817893__fetted
fitted104716663__fitted
flatted114012943_flatted
gelated93615633gela_ted
gestated102910573gestated
hatted104921513__hatted
hearted113314023he_arted
heated104525593he_a_ted
hefted134911423hef__ted
ideated9310973ide_a_ted
jetted143915083je__tted
legated92513983lega_ted
letted74118543le__tted
levanted1245323levanted
matted94521413__matted
meated94222403me_a_ted
negated93413233nega_ted
netted74118713ne__tted
patted94724683__patted
petted94121523pe__tted
platted103614263_platted
ratted74923343__ratted
reacted103015713re_acted
rebaited11410543rebaited
rebated103619703reba_ted
rebutted11126783rebutted
recanted112513513recanted
redacted12410243redacted
redated93120923reda_ted
refaced133713573refa_ced
refasten1136103refasten
refected142311663refected
reflated123514293reflated
refracted1557393refracted
refuted114313803ref_uted
related83327573rela_ted
remated103522473rema_ted
remitted113312073remitted
repasted112611533repasted
repotted1139283repotted
restated93120183restated
retasted92412113retasted
retted74826313re__tted
revetted122210943revetted
rewetted12228353rewetted
scatted103512773_scatted
seated75131053se_a_ted
sedated93714343seda_ted
slatted84015183_slatted
spatted104014143_spatted
splatted11356743splatted
squatted1835343squatted
swatted114110693_swatted
tatted74920533__tatted
teated74924023te_a_ted
tenanted937043tenanted
unfitted1238163unfitted
unhatted1238183unhatted
unmatted1138293unmatted
vatted104214733__vatted
vetted104316323ve__tted
wetted103717023we__tted
yeasted1138503ye_asted

Search took 9 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.1531167915.0
2DLD Change Limit1461622297.95618371.3
3Display Results2292290.0932462.4
 (SQL Overall)1786912298.20221786.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.