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

206 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
defatting143610(None) 
deratting1139511deratting
befitting15236622befitting
debating123213732deba_ting
decanting132510632decanting
defacing15238682defa_cing
defaming15238462defa_ming
defanging1535332defanging
defaulting1543392defaulting
defeating142311972defeating
defecting162510222defecting
deflating142610712deflating
delating103119602dela_ting
demasting1338452demasting
demitting13239072demitting
departing1349512departing
derating103222282dera_ting
desalting1138842desalting
dratting10389662d_ratting
fatting113818702__fatting
refitting132811122refitting
aerating92821003aera_ting
batting104422273__batting
beating104326873be_a_ting
befalling15226503befalling
befretting1644793befretting
begetting13186583begetting
berating113220763bera_ting
besetting12268423besetting
besotting12256873besotting
betting103921403be__tting
blatting114111653_blatting
catting103922643__catting
chatting142810143_chatting
darting94020663d__arting
dating85326483d__a_ting
dauting93814763d__auting
dawting123610673d__awting
deafening1476273deafening
deairing10311893de_airing
dealing94323233de_a_ling
deaning94020473de_a_ning
deashing134210953de_ashing
deaving123814753de_a_ving
debagging1533593debagging
debarking1735383debarking
debarring1335723debarring
debasing12238063deba_sing
debiting122511203de_biting
debuting12268633de_buting
decamping1734943decamping
decaying15239453deca_ying
decocting1538123decocting
deducting1436843deducting
defalcating1844343defalcating
defang1137753defa___ng
defatted1335673defatt_ed
defecating17237783defecating
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
defiling132812463def_iling
defining133711803def_ining
defleaing1444743defleaing
deflecting1736503deflecting
defoaming1645653defoaming
defogging1653863defogging
deforcing1636063deforcing
deforming1636703deforming
defragging1742823defragging
defrauding1642923defrauding
defraying1735853defraying
defrosting1544493defrosting
defueling14255093defueling
defunding15216123defunding
defusing13227943def_using
defuzing22195253def_uzing
defying15328823def__ying
degassing1234823degassing
degusting1236163degusting
dehorting1447213dehorting
dejecting20217793dejecting
delaying133210973dela_ying
deleting103314423de_leting
delisting112710503delisting
demanding14237923demanding
demarking1736773demarking
dementing13311043dementing
demoting12311423de_moting
denaturing12115863denaturing
denoting10311753de_noting
denting94422183de__nting
depainting14156153depainting
depicting1537813depicting
depleting1378193depleting
deporting1369593deporting
deputing12238793de_puting
derailing112011313derailing
deranging1238063deranging
desanding12207653desanding
descanting1446923descanting
deserting11713143deserting
desisting112810383desisting
despiting13179323despiting
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
detecting13259983detecting
detesting112610323detesting
detracting1438713detracting
devaluing1434833devaluing
devastating1644703devastating
devesting14249903devesting
deviating14311083deviating
devoting1338823de_voting
dewatering1545773dewatering
dewaxing20215293dewa_xing
dictating1338883dictating
dilating102714913dila_ting
doating93816863d_oa_ting
donating10311803dona_ting
dotting93314483d__otting
drafting13339413d_rafting
duetting1047183d_uetting
easting84924303_e_asting
eating75134403_e_a_ting
elating83423083_ela_ting
emitting112410353_emitting
enacting11311363_enacting
estating92614993_estating
exacting1838523_exacting
exalting1638033_exalting
farting114120753__farting
fasting114522833__fasting
fating105328673__fa_ting
fatling113815683__fatling
feasting122011323fe_asting
fetting113517873__fetting
fitting113516563__fitting
flatting123511253_flatting
gelating103015733gela_ting
gestating11229983gestating
getting93316563ge__tting
hatting113920233__hatting
hearting12513123he_arting
heating114024323he_a_ting
hefting144510913hef__ting
ideating10311703ide_a_ting
jetting153815343je__tting
leftwing1532973lef_twing
legating102313113lega_ting
letting83218533le__tting
levanting1345523levanting
matting103620143__matting
negating102012833nega_ting
netting84018763ne__tting
patting103722343__patting
petting103720953pe__tting
platting114813033_platting
ratting83822363__ratting
reacting113317893re_acting
rebaiting12311643rebaiting
rebating112418343reba_ting
rebutting1237523rebutting
recanting122414823recanting
recasting122414233recasting
recutting1239483recutting
redacting13612303redacting
redating102620173reda_ting
refacing142512813refa_cing
refalling132010423refalling
refecting152413353refecting
reflating132514713reflating
refracting1638733refracting
refuting121911903ref_uting
relating92725443rela_ting
reletting102713943reletting
remating112322423rema_ting
remitting122412623remitting
repasting122312843repasting
repotting12511123repotting
resetting102816293resetting
resitting103414873resitting
restating102319413restating
retasting102513413retasting
retting83425883re__tting
revetting132912633revetting
rewetting132710443rewetting
scatting113311813_scatting
seating84130683se_a_ting
sedating103014113seda_ting
setting83621393se__tting
slatting94014233_slatting
spatting113111763_spatting
splatting1235983splatting
squatting1934513squatting
swatting12309593_swatting
tatting84019523__tatting
tenanting1036213tenanting
unfitting1336423unfitting
unhatting1335873unhatting
vatting113614853__vatting
vetting114216563ve__tting
wetting114117383we__tting
yeasting12188923ye_asting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412067.47019898.4
3Display Results2062060.0932215.1
 (SQL Overall)1786912067.98622375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.