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

221 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
detesting11261032(None) 
detecting13259981detecting
devesting14249901devesting
retesting102614601retesting
attesting1036382attesting
defeating142311972defeating
defecting162510222defecting
degusting1236162degusting
dejecting20217792dejecting
deleting103314422dele_ting
delisting112710502delisting
demasting1338452demasting
dementing13311042dementing
deserting11713142deserting
desisting112810382desisting
deterging1237852deterging
deterring1138622deterring
digesting12208672digesting
divesting14298482divesting
egesting1039012_egesting
obtesting1245882obtesting
pretesting131810682pretesting
reesting93118272re_esting
renesting102514702renesting
retasting102513412retasting
revesting132814122revesting
testing86021052__testing
arresting1038633arresting
beestings12335923be_estings
beeswing14255763be_eswing
begetting13186583begetting
bemisting1438073bemisting
besetting12268423besetting
besting104923923__besting
betting103921403bet__ting
celestine11147943celestine
cementing1438763cementing
contesting13312213contesting
cresting114017043_cresting
deaerating12311563deaerating
deashing134210953de_ashing
debasing12238063debas_ing
debating123213733de_bating
debeaking1735923debeaking
debiting122511203de_biting
debuting12268633de_buting
decanting132510633decanting
deceasing1338403deceasing
deceiving1635733deceiving
decentring1446753decentring
decerning1337293decerning
decocting1538123decocting
deducting1436843deducting
deeding103315123de_e_ding
deeming113913123de_e_ming
defatting1436103defatting
defecating17237783defecating
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
deflating142610713deflating
deflecting1736503deflecting
deforesting1654793deforesting
defrosting1544493defrosting
defusing13227933defus_ing
degassing1234823degassing
degerming1435753degerming
dehiscing1643733dehiscing
dehorting1447213dehorting
dekeing13358353deke__ing
delating103119603de_lating
deleading1237773deleading
deleaving1436263deleaving
delegating1337673delegating
deleing93313953dele__ing
demeaning1337243demeaning
demerging1436643demerging
demeriting1448683demeriting
demising122012523demis_ing
demitting13239073demitting
demoting12311423de_moting
denoting10311753de_noting
denting94422183d__enting
departing1349513departing
depending14208783depending
deperming1537113deperming
depicting1537813depicting
depleting1378193depleting
deporting1369593deporting
deposing12129773depos_ing
depositing1446933depositing
depressing1448093depressing
deputing12238793de_puting
derating103222283de_rating
deratting1139513deratting
desalting1138843desalting
deserving1497903deserving
desexing1736293dese_xing
despiting13179323despiting
destine83719953d__estine
destiny113111463d__estiny
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
detection121310413detection
detections131410043detections
detective1548103detective
detention10169543detention
detentions11148803detentions
detentist1049323detentist
determine1249033determine
detest74122843detest___
detested10279623detest_ed
detester9239683detest_er
detesters10298303detesters
detests83711743detest__s
deticking1736043deticking
detonating1248823detonating
detouring1136973detouring
detoxing1736313det_oxing
detracting1438713detracting
detruding1245193detruding
deuterating1347273deuterating
deveining1436393deveining
develing133212733deve_ling
deviating14311083deviating
devising133111523devis_ing
devoting1338823de_voting
dieting93616833d_ie_ting
directing1338823directing
distasting1248023distasting
diverting142410333diverting
dotting93314483dot__ting
dressing102810423d_ressing
dueting93814393d_ue_ting
duetting1047183d_uetting
dusting93618993d__usting
easting84924303_e_asting
ejecting18268163_ejecting
electing112113783_electing
erecting112415063_erecting
everting122213133_everting
exerting162211153_exerting
existing1639073_existing
feasting122011323fe_asting
fetting113517873fet__ting
foresting13311363foresting
getting93316563get__ting
guesting1058463_guesting
heisting123411043he_isting
infesting13109513infesting
ingesting11129623ingesting
intestine9411853intestine
investing13119393investing
jesting154317713__jesting
jetting153815343jet__ting
letting83218533let__ting
lutestring1143473lutestring
meeting103314963me_e_ting
metering112915633mete_ring
molesting1237753molesting
nesting84320443__nesting
netting84018763net__ting
outeating10814493outeating
patenting1248943patenting
petering112516813pete_ring
petting103720953pet__ting
pretasting13239283pretasting
pretexting20206973pretexting
priesting1239483priesting
protesting131910253protesting
questing1838273_questing
recasting122414233recasting
recessing12611013recessing
refecting152413353refecting
reheating132314913reheating
rejecting192211153rejecting
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
remeeting12311433remeeting
remelting12311703remelting
repasting122312843repasting
repeating122618983repeating
repenting122316553repenting
requesting2046313requesting
rerenting102617663rerenting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
resisting103215313resisting
resting85031183__resting
reteaming122110443reteaming
retearing102214253retearing
retelling102112493retelling
retestify1543753retestify
retinting102215253retinting
retorting10613273retorting
retreating111414773retreating
retting83425883ret__ting
retwisting1445633retwisting
reverting132315133reverting
revetting132912633revetting
rewetting132710443rewetting
selecting12310533selecting
setting83621393set__ting
stetting93410713_stetting
tasting84624213__tasting
tempesting1544453tempesting
tenting84621153__tenting
unresting10311133unresting
vesting114618683__vesting
vetting114216563vet__ting
weeting113816053we_e_ting
westing115020273__westing
wetting114117383wet__ting
wresting123811833_wresting
yeasting12188923ye_asting
zesting174515333__zesting

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.406440125.6
2DLD Change Limit1486412216.47022973.9
3Display Results2212210.1062084.9
 (SQL Overall)1786912216.98225593.1
 
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.