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

370 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
resecting12281648(None) 
refecting152413351refecting
rejecting192211151rejecting
reseating102421531reseating
resenting102619291resenting
resetting102816291resetting
respecting1549881respecting
besetting12268422besetting
bisecting1436972bisecting
defecting162510222defecting
dejecting20217792dejecting
deserting11713142deserting
detecting13259982detecting
ejecting18268162_ejecting
electing112113782_electing
erecting112415062_erecting
exsecting1935932exsecting
prelecting15310162prelecting
presenting131013022presenting
presetting131010832presetting
prosecting15189812prosecting
reacting113317892re_acting
redacting13612302redacting
reejecting2045812reejecting
reelecting1338782reelecting
reerecting1339972reerecting
reesting93118272re_esting
reflecting1638822reflecting
reheating132314912reheating
relenting102716772relenting
reletting102713942reletting
relucting1239772relucting
remeeting12311432remeeting
remelting12311702remelting
renesting102514702renesting
repeating122618982repeating
repenting122316552repenting
rerenting102617662rerenting
rescuing1139622res_cuing
resealing102115672resealing
resection111613272resection
resections121513032resections
resecuring1345122resecuring
reseeding112410492reseeding
reseeing92412622rese_eing
reseeking14208492reseeking
reseizing19311232reseizing
reselecting1446022reselecting
reselling102213832reselling
resending112313362resending
reserving131110642reserving
resettling1135892resettling
resewing122712262rese_wing
resifting133512092resifting
resisting103215312resisting
resiting93521122res_iting
resitting103414872resitting
reslating102516992reslating
resmelting1337262resmelting
resorting10614612resorting
respiting121912862respiting
restating102319412restating
resting85031182res__ting
resulting10311082resulting
retesting102614602retesting
reverting132315132reverting
revesting132814122revesting
revetting132912632revetting
rewetting132710442rewetting
selecting12310532selecting
trisecting1345502trisecting
absenting1236993absenting
advecting1645113advecting
affecting1845233affecting
assenting1038163assenting
asserting1038663asserting
bedecking1934283bedecking
begetting13186583begetting
beseeching1843363beseeching
beseeming1435143beseeming
besotting12256873besotting
besting104923923bes__ting
breeching17236473bre_eching
breveting1536263breve_ting
brevetting1644333brevetting
caseating12311743caseating
cementing1438763cementing
coerecting15218783coerecting
cresting114017043cres__ting
decocting1538123decocting
deducting1436843deducting
defeating142311973defeating
defecating17237783defecating
deflecting1736503deflecting
deleting103314423dele_ting
dementing13311043dementing
depicting1537813depicting
desalting1138843desalting
desecrating1548093desecrating
deselecting1544473deselecting
deserving1497903deserving
desexing1736293dese_xing
desisting112810383desisting
despiting13179323despiting
detesting112610323detesting
devesting14249903devesting
directing1338823directing
disjecting2177243disjecting
dissecting14139473dissecting
effecting1845583effecting
egesting1039013_egesting
enacting11311363_enacting
eructing112110173_eructing
escoting1158713_escoting
estating92614993_estating
everting122213133_everting
evicting1437483_evicting
exacting1838523_exacting
executing1945583_executing
exerting162211153_exerting
expecting2146693expecting
exserting1736663exserting
frescoing1544683fres_coing
gestating11229983gestating
greeting103112353gre_e_ting
infecting15109673infecting
injecting1997693injecting
inserting10914243inserting
insetting1079283insetting
inspecting1546223inspecting
jesting154317713jes__ting
leeching14318373le_eching
meeting103314963me_e_ting
misacting1439083misacting
miseating121215433miseating
neglecting1444543neglecting
nesting84320443nes__ting
objecting2144053objecting
perfecting1847513perfecting
persecuting1643833persecuting
praelecting1644533praelecting
preacting142412533pre_acting
precenting151012153precenting
predicting1649873predicting
preelecting1646473preelecting
preerecting1646143preerecting
preheating16310723preheating
preselecting1744293preselecting
preselling1338693preselling
preserving1637363preserving
presettling1444453presettling
presifting1638083presifting
presorting1339983presorting
pretesting131810683pretesting
pretexting20206973pretexting
preventing161210263preventing
projecting22177243projecting
prosecuting1645023prosecuting
prospecting1845853prospecting
protecting151910213protecting
reaching143317203re_aching
reasserting1246153reasserting
rebaiting12311643rebaiting
rebating112418343re_bating
rebelling122111163rebelling
rebooting12139023rebooting
rebutting1237523rebutting
recanting122414823recanting
recasting122414233recasting
receding122713763rece_ding
receipting1546753receipting
receiving1538993receiving
recessing12611013recessing
rechecking2244463rechecking
reciting113118073re_citing
recking144319923r__ecking
recoating121317463recoating
recocking18138373recocking
recrating121318793recrating
recreating131214583recreating
recutting1239483recutting
recycling1734903recycling
redating102620173re_dating
redeciding1544703redeciding
redeeming1337363redeeming
redefecting1844373redefecting
redefying1736093redefying
redenying1437783redenying
redirecting1545613redirecting
redocking17126783redocking
reducing12310203reduc_ing
reechoing1545293re_echoing
reeding94124133re_e_ding
reediting11310953reediting
reedling102414273re_edling
reefing114016863re_e_fing
reeking123318643re_e_king
reeling83126863re_e_ling
reenacting1357353reenacting
reeving113717663re_e_ving
reexecuting2142543reexecuting
refacing142512813refac_ing
refection141512283refection
refections151811643refections
refective1749113refective
refeeding14247933refeeding
refeeling13229313refeeling
refelling132211313refelling
refencing15188853refencing
referring1338033referring
refitting132811123refitting
reflating132514713reflating
refracting1638733refracting
refuting121911903re_futing
regearing112211413regearing
regelating1239953regelating
regrating111316213regrating
regreeting1237343regreeting
regretting1237783regretting
rehearing132211763rehearing
reheeling13218263reheeling
rehemming1734743rehemming
reinciting1347103reinciting
reinfecting1745153reinfecting
reinjecting2144453reinjecting
reinserting1256903reinserting
reinspecting1763203reinspecting
rejectingly2442943rejectingly
rejection181710253rejection
rejections191510103rejections
rejective2148253rejective
rekeying1637563reke_ying
relacing112516043relac_ing
relating92725443re_lating
releasing10411013releasing
relegating1239483relegating
relending112412023relending
relisting102414353relisting
relocating13310873relocating
relocking16137683relocking
remating112322413re_mating
remedying1635143remedying
remending132311313remending
remerging1358323remerging
reminting122315103reminting
remitting122412623remitting
reneging102111533rene_ging
renewing121910713rene_wing
renting84026853r__enting
reobjecting2343033reobjecting
repacking1838283repacking
repasting122312843repasting
repealing122513543repealing
repegging1435593repegging
repelling122312753repelling
reperking1638703reperking
replating122217403replating
reporting12513903reporting
repotting12511123repotting
reputing112412603re_puting
requesting2046313requesting
requiting1939883requiting
reracking1639313reracking
rereading111212713rereading
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433res_awing
resaying122512453res_aying
rescaling122212013rescaling
rescind10410393res_c_ind
rescoring12310603rescoring
researching1743423researching
resect84424703resect___
resected112514743resect_ed
resects94115593resect__s
resembling1544733resembling
resentive12410723resentive
reserpine1147523reserpine
reshaping1557743reshaping
reshaving1657273reshaving
reshining13310743reshining
reshoeing1336593reshoeing
reshooting1436223reshooting
reshowing1646633reshowing
residing103015473res_iding
resighting1546073resighting
resigning1139463resigning
resiling93520173res_iling
resinating11313733resinating
resining92919553res_ining
resittings11264553resittings
resizing182714163res_izing
resketching2142273resketching
resoaking1439373resoaking
resodding1237203resodding
resoling92916303res_oling
resolving1337743resolving
resonating11311263resonating
resorbing1269353resorbing
resowing123111523res_owing
respacing1438893respacing
respading1338803respading
respeaking1736803respeaking
respective1747623respective
respelling1347973respelling
respiring12159903respiring
respotting1347113respotting
respring111614063res_pring
restacking1737183restacking
restaging112410853restaging
restarting11310663restarting
restocking1745703restocking
restoking1438193restoking
restoring10314613restoring
restricting1449303restricting
restring91518783res_tring
restyling1337923restyling
resubjecting2451993resubjecting
resuming11310083res_uming
resurging1138613resurging
resurrecting1553123resurrecting
retacking1658973retacking
retasting102513413retasting
retching143412173re_tching
reteaching1636023reteaching
reteaming122110443reteaming
retearing102214253retearing
retelling102112493retelling
retinting102215253retinting
retorting10613273retorting
retracting13311933retracting
retreating111414773retreating
retting83425883r__etting
reuniting10310693reuniting
revealing132611883revealing
reveling123117083reve_ling
revelling132412553revelling
revenging1438083revenging
reverbing15248593reverbing
revering122918073reve_ring
reversing132611483reversing
revolting1339633revolting
revoting12312033re_voting
rewearing132310703rewearing
reweaving16227073reweaving
rewedding1535093rewedding
rewelding1436913rewelding
rewriting13310413rewriting
rezeroing1935933rezeroing
riveting12139443rive_ting
rivetting13256413rivetting
russeting1065323russeting
russetting1184253russetting
rusting83821263rus__ting
seating84130683__seating
setting83621393__setting
suspecting1565703suspecting
testing86021053tes__ting
trajecting2044293trajecting
transecting1447373transecting
unseating10713203unseating
unsetting1088993unsetting
upsetting1275563upsetting
vesicating1646893vesicating
vesting114618683ves__ting
weeting113816053we_e_ting
westing115020273wes__ting
wresting123811833wres__ting
zesting174515333zes__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.406440125.6
2DLD Change Limit1486413707.22020587.4
3Display Results3703700.1702176.5
 (SQL Overall)1786913707.79622920.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.