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 “detecting” 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
detecting1325998(None) 
defecting162510221defecting
dejecting20217791dejecting
detesting112610321detesting
decocting1538122decocting
deducting1436842deducting
defeating142311972defeating
defecating17237782defecating
deflecting1736502deflecting
deleting103314422dele_ting
dementing13311042dementing
depicting1537812depicting
deserting11713142deserting
detaching1637262detaching
detection121310412detection
detections131410042detections
detective1548102detective
deterging1237852deterging
deterring1138622deterring
deticking1736042deticking
detracting1438712detracting
devesting14249902devesting
directing1338812directing
ejecting18268162_ejecting
electing112113782_electing
erecting112415062_erecting
refecting152413352refecting
rejecting192211152rejecting
resecting122816482resecting
retesting102614602retesting
selecting12310532selecting
advecting1645113advecting
affecting1845233affecting
attesting1036383attesting
bedecking1934283bedecking
begetting13186583begetting
besetting12268423besetting
betting103921403bet__ting
bisecting1436973bisecting
cathecting1844833cathecting
cementing1438763cementing
coerecting15218783coerecting
deaerating12311563deaerating
debating123213733de_bating
debeaking1735923debeaking
debiting122511203de_biting
debuting12268633de_buting
decanting132510633decanting
deceasing1338403deceasing
deceiving1635733deceiving
decentring1446753decentring
decerning1337293decerning
decking153915593d__ecking
dedicating1539143dedicating
deducing1336423deduc_ing
deeding103315123de_e_ding
deeming113913123de_e_ming
defacing15238683defac_ing
defatting1436103defatting
defection151610643defection
defections161510203defections
defective1848003defective
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
deflating142610713deflating
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
destructing1546113destructing
detailing112510413detailing
detaining112510473detaining
detect94217403detect___
detected12289733detect_ed
detecter11298733detect_er
detecters12217753detecters
detectives1645783detectives
detector11278323detect_or
detectors12278303detectors
detects104011093detect__s
detention10169543detention
detentions11148803detentions
detentist1049323detentist
determine1249033determine
detonating1248823detonating
detouring1136973detouring
detoxing1736313det_oxing
detruding1245193detruding
deucing1139393de_uc_ing
deuterating1347273deuterating
deveining1436393deveining
develing133212733deve_ling
deviating14311083deviating
devoting1338823de_voting
dieting93616833d_ie_ting
digesting12208673digesting
disjecting2177243disjecting
dissecting14139473dissecting
ditching15349943dit_ching
diverting142410333diverting
divesting14298483divesting
dotting93314483dot__ting
ducting113713593d__ucting
dueting93814393d_ue_ting
duetting1047183d_uetting
effecting1845583effecting
egesting1039013_egesting
enacting11311363_enacting
eructing112110173_eructing
etching134511843_et_ching
everting122213133_everting
evicting1437483_evicting
exacting1838523_exacting
executing1945583_executing
exerting162211153_exerting
expecting2146693expecting
exsecting1935933exsecting
fetching17298413fet_ching
fetting113517873fet__ting
getting93316563get__ting
infecting15109673infecting
injecting1997693injecting
jetting153815343jet__ting
leeching14318373le_eching
letching143810263let_ching
letting83218533let__ting
meeting103314963me_e_ting
metering112915633mete_ring
neglecting1444543neglecting
netting84018763net__ting
objecting2144053objecting
obtesting1245883obtesting
outacting1239213outacting
outeating10814493outeating
patenting1248943patenting
perfecting1847513perfecting
petering112516813pete_ring
petting103720953pet__ting
prelecting15310163prelecting
pretesting131810683pretesting
pretexting20206973pretexting
protecting151910213protecting
reacting113317893re_acting
redacting13612303redacting
redefecting1844373redefecting
reejecting2045813reejecting
reelecting1338783reelecting
reerecting1339973reerecting
reesting93118273re_esting
reflecting1638823reflecting
reheating132314913reheating
relenting102716773relenting
reletting102713943reletting
relucting1239773relucting
remeeting12311433remeeting
remelting12311703remelting
renesting102514703renesting
repeating122618983repeating
repenting122316553repenting
rerenting102617663rerenting
reseating102421533reseating
resenting102619293resenting
resetting102816293resetting
respecting1549883respecting
retacking1658973retacking
retasting102513413retasting
retching143412173ret_ching
reteaching1636023reteaching
reteaming122110443reteaming
retearing102214253retearing
retelling102112493retelling
retinting102215253retinting
retorting10613273retorting
retracting13311933retracting
retreating111414773retreating
retting83425883ret__ting
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
rewetting132710443rewetting
setting83621393set__ting
stetting93410713_stetting
tenting84621153__tenting
testing86021053__testing
vetting114216563vet__ting
weeting113816053we_e_ting
wetting114117383wet__ting

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.1701051123.5
2DLD Change Limit1486412237.36020195.8
3Display Results2232230.1102027.3
 (SQL Overall)1786912237.64023388.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.