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

223 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
defecting16251022(None) 
defeating142311971defeating
defecating17237781defecating
deflecting1736501deflecting
dejecting20217791dejecting
detecting13259981detecting
refecting152413351refecting
affecting1845232affecting
decocting1538122decocting
deducting1436842deducting
defacing15238682defac_ing
defatting1436102defatting
defection151610642defection
defections161510202defections
defective1848002defective
defencing16226692defencing
defending15298352defending
defensing14217002defensing
deferring1436142deferring
deflating142610712deflating
deleting103314422dele_ting
dementing13311042dementing
depicting1537812depicting
deserting11713142deserting
detesting112610322detesting
devesting14249902devesting
directing1338822directing
effecting1845582effecting
ejecting18268162_ejecting
electing112113782_electing
erecting112415062_erecting
infecting15109672infecting
perfecting1847512perfecting
redefecting1844372redefecting
reflecting1638822reflecting
rejecting192211152rejecting
resecting122816482resecting
selecting12310532selecting
advecting1645113advecting
bedecking1934283bedecking
befitting15236623befitting
beflecking2243033beflecking
befretting1644793befretting
begetting13186583begetting
besetting12268423besetting
bisecting1436973bisecting
cementing1438763cementing
coerecting15218783coerecting
confecting18310553confecting
deaerating12311563deaerating
deafening1476273deafe_ning
debating123213733de_bating
debeaking1735923debeaking
debiting122511203de_biting
debuting12268633de_buting
decanting132510633decanting
deceasing1338403deceasing
deceiving1635733deceiving
decentring1446753decentring
decerning1337293decerning
decking153915593d__ecking
dedicating1539143dedicating
deducing1336423deduc_ing
deeding103315123de_e_ding
deeming113913123de_e_ming
defalcating1844343defalcating
defaming15238463def_aming
defanging1535333defanging
defaulting1543393defaulting
defeatism1544413defeatism
defeatist1356603defeatist
defecation1679803defecation
defecations1779003defecations
defect124816173defect___
defected15289973defect_ed
defectives1945683defectives
defector14277953defect_or
defectors15237883defectors
defects134511523defect__s
defiling132812463def_iling
defining133711803def_ining
defleaing1444743defleaing
deflection16147733deflection
deflections17187323deflections
deflective1956093deflective
defoaming1645653defoaming
defocusing1752813defocusing
defogging1653863defogging
deforcing1636063deforcing
deforesting1654793deforesting
deforming1636703deforming
defraying1735853defraying
defrocking2143153defrocking
defrosting1544493defrosting
defueling14255093defueling
defuelling1573543defuelling
defunding15216123defunding
defusing13227933def_using
defuzing22195253def_uzing
defying15328823def__ying
degerming1435753degerming
degusting1236163degusting
dehorting1447213dehorting
deicing11312193de_ic_ing
dejection19178663dejection
dejections20168353dejections
dekeing13358353deke__ing
delating103119603de_lating
deleading1237773deleading
deleaving1436263deleaving
delectating1545993delectating
delegating1337673delegating
deleing93313953dele__ing
delisting112710503delisting
demasting1338453demasting
demeaning1337243demeaning
demerging1436643demerging
demeriting1448683demeriting
demitting13239073demitting
demoting12311423de_moting
denoting10311753de_noting
denting94422183d__enting
departing1349513departing
depending14208783depending
deperming1537113deperming
depleting1378193depleting
deporting1369593deporting
deprecating1777283deprecating
deputing12238793de_puting
derating103222283de_rating
deratting1139513deratting
desalting1138843desalting
desecrating1548093desecrating
deselecting1544473deselecting
deserving1497903deserving
desexing1736293dese_xing
desisting112810383desisting
despiting13179323despiting
detaching1637263detaching
detection121310413detection
detections131410043detections
detective1548103detective
deterging1237853deterging
deterring1138623deterring
deticking1736043deticking
detracting1438713detracting
deucing1139393de_uc_ing
deveining1436393deveining
develing133212733deve_ling
deviating14311083deviating
devoting1338823de_voting
dieting93616833d_ie_ting
digesting12208673digesting
disjecting2177243disjecting
dissecting14139473dissecting
diverting142410333diverting
divesting14298483divesting
ducting113713593d__ucting
dueting93814393d_ue_ting
duetting1047183d_uetting
egesting1039013_egesting
enacting11311363_enacting
eructing112110173_eructing
everting122213133_everting
evicting1437483_evicting
exacting1838523_exacting
executing1945583_executing
exerting162211153_exerting
expecting2146693expecting
exsecting1935933exsecting
felting113515213__felting
feting104417793__fe_ting
fetting113517873__fetting
hefting144510913hef__ting
infesting13109513infesting
inflecting1646313inflecting
injecting1997693injecting
leeching14318373le_eching
meeting103314963me_e_ting
neglecting1444543neglecting
objecting2144053objecting
prelecting15310163prelecting
reacting113317893re_acting
redacting13612303redacting
redefeating1645333redefeating
reejecting2045813reejecting
reelecting1338783reelecting
reerecting1339973reerecting
reesting93118273re_esting
refacing142512813refac_ing
refection141512283refection
refections151811643refections
refective1749113refective
refeeding14247933refeeding
refeeling13229313refeeling
refelling132211313refelling
refencing15188853refencing
referring1338033referring
refitting132811123refitting
reflating132514713reflating
refracting1638733refracting
refuting121911903ref_uting
reheating132314913reheating
reinfecting1745153reinfecting
relenting102716773relenting
reletting102713943reletting
relucting1239773relucting
remeeting12311433remeeting
remelting12311703remelting
renesting102514703renesting
repeating122618983repeating
repenting122316553repenting
rerenting102617663rerenting
reseating102421533reseating
resenting102619293resenting
resetting102816293resetting
respecting1549883respecting
retesting102614603retesting
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
rewetting132710443rewetting
weeting113816053we_e_ting

Search took 7 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.420425454.8
2DLD Change Limit1486412236.37623312.6
3Display Results2232230.1102027.3
 (SQL Overall)1786912236.90625874.7
 
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.