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

356 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
resorting1061461(None) 
presorting1339981presorting
reporting12513901reporting
resorbing1269351resorbing
retorting10613271retorting
assorting1037302assorting
besotting12256872besotting
dehorting1447212dehorting
deporting1369592deporting
deserting11713142deserting
desorbing1346362desorbing
escorting1237712_escorting
reassorting1245022reassorting
rebooting12139022rebooting
reboring11312782rebor_ing
recoating121317462recoating
recording131311622recording
recorking16149642recorking
reforging1437662reforging
reforming1538562reforming
regorging1236822regorging
repotting12511122repotting
rerouting10311872rerouting
rescoring12310602rescor_ing
reseating102421532reseating
resecting122816482resecting
resenting102619292resenting
reserving131110642reserving
resetting102816292resetting
reshooting1436222reshooting
resifting133512092resifting
resisting103215312resisting
resiting93521122res_iting
resitting103414872resitting
reslating102516992reslating
resoaking1439372resoaking
resodding1237202resodding
resoling92916302reso_ling
resolving1337742resolving
resonating11311262resonating
resorcin1046822resorcin_
resorcins1146982resorcins
resowing123111522reso_wing
respiting121912862respiting
respotting1347112respotting
respring111614062respr_ing
restarting11310662restarting
restating102319412restating
resting85031182res__ting
restoring10314612restor_ing
restring91518782restr_ing
resulting10311082resulting
resurging1138612resurging
reverting132315132reverting
revolting1339632revolting
revoting12312032revo_ting
rewording14158542rewording
reworking17136872reworking
sorting83221812__sorting
aborting11710253_aborting
absorbing1444483absorbing
adsorbing1344123adsorbing
asserting1038663asserting
besetting12268423besetting
beshouting1644023beshouting
besoothing1693163besoothing
besting104923923bes__ting
beworming1734553beworming
cavorting1536063cavorting
censoring1238783censor_ing
consorting13410743consorting
creosoting1343793creosoting
cresting114017043cres__ting
decocting1538123decocting
decorating14312073decorating
deforcing1636063deforcing
deforming1636703deforming
dehorning1455243dehorning
demoting12311423demo_ting
denoting10311753deno_ting
departing1349513departing
desalting1138843desalting
descrying1635103descrying
deserving1497903deserving
desiring10312143desir_ing
desisting112810383desisting
desolating1239463desolating
despiting13179323despiting
devoting1338823devo_ting
deworming1635043deworming
disporting1439823disporting
distorting1239583distorting
emoting10313563_emo_ting
escoting1158713_escoting
estating92614993_estating
everting122213133_everting
exerting162211153_exerting
exhorting2045733exhorting
exporting1937323exporting
exserting1736663exserting
extorting1746763extorting
gestating11229983gestating
hearting12513123he_arting
importing1438193importing
inserting10914243inserting
intorting10311413intorting
jesting154317713jes__ting
missorting1347123missorting
nesting84320443nes__ting
perorating13313133perorating
porting103021783__porting
preforming1846233preforming
prescoring1547433prescor_ing
presenting131013023presenting
preserving1637363preserving
presetting131010833presetting
presifting1638083presifting
presoaking1736253presoaking
presolving1644363presolving
prestoring13310303prestor_ing
preworking2044233preworking
ragouting1134893ragouting
razoring1836443razor_ing
reabsorbing1642763reabsorbing
reacting113317893re_acting
readopting1465513readopting
readorning1245723readorning
rearing83128783re_ar_ing
rearming111413613re_arming
reasoning10310203reaso_ning
reasserting1246153reasserting
rebaiting12311643rebaiting
rebating112418343re_bating
reboarding1445673reboarding
rebodying1635003rebodying
reboiling12149823reboiling
rebooking16146393rebooking
rebottling1343733rebottling
reburying1535193reburying
rebutting1237523rebutting
recanting122414823recanting
recasting122414233recasting
recharting1637213recharting
reciting113118073re_citing
recoaling121312453recoaling
recocking18138373recocking
recoding122213853reco_ding
recoiling121412413recoiling
recoining121313803recoining
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recordings14144653recordings
recounting1339193recounting
recouping1438363recouping
recrating121318793recrating
recurring1237953recurring
recurving1536773recurving
recutting1239483recutting
redacting13612303redacting
redating102620173re_dating
redocking17126783redocking
redoing93516733redo__ing
redonning11127643redonning
redrying13209023re_drying
redshirting1643263redshirting
reearning1039053reearning
reediting11310953reediting
reesting93118273re_esting
reexporting2143423reexporting
refecting152413353refecting
referring1338033referring
refiring123513923refir_ing
refitting132811123refitting
reflating132514713reflating
refloating14198323refloating
refolding1437453refolding
reforesting1546193reforesting
refortify1842833refortify
refronting1437273refronting
refrying15278903re_frying
refuting121911903re_futing
regarding12149153regarding
regrating111316213regrating
regrowing1436673regrowing
reheating132314913reheating
rehiring122911883rehir_ing
rehousing1337253rehousing
reimporting1644093reimporting
reinserting1256903reinserting
rejecting192211153rejecting
rejoicing19136943rejoicing
rejoining17149223rejoining
reknotting1564233reknotting
relating92725443re_lating
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
reloading1189883reloading
reloaning10710483reloaning
relocating13310873relocating
relocking16137683relocking
relooking14167143relooking
relucting1239773relucting
remarking1638893remarking
remating112322413re_mating
remeeting12311433remeeting
remelting12311703remelting
remerging1358323remerging
reminting122315103reminting
remitting122412623remitting
remolding1338163remolding
remounting1346673remounting
removing1439083remo_ving
renesting102514703renesting
renovating1447423renovating
renowning1336083renowning
renting84026853re__nting
reoiling93217213re_oiling
reparking1638923reparking
repasting122312843repasting
repeating122618983repeating
repenting122316553repenting
reperking1638703reperking
replating122217403replating
replotting1357043replotting
repolling122110203repolling
reposing111213803repo_sing
repositing13310493repositing
repouring12310073repouring
reprobing1438073reprobing
reproving1538413reproving
reputing112412603re_puting
requiting1939883requiting
rerenting102617663rerenting
rerolling102210373rerolling
reroofing1336863reroofing
resailing103314253resailing
resaluting1137393resaluting
resawing122311433res_awing
resaying122512453res_aying
rescaling122212013rescaling
rescuing1139623res_cuing
resealing102115673resealing
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reseizing19311233reseizing
reselling102213833reselling
resending112313363resending
reserpine1147523reserpine
resettling1135893resettling
resewing122712263res_ewing
reshaping1557743reshaping
reshaving1657273reshaving
reshining13310743reshining
reshoeing1336593reshoeing
reshowing1646633reshowing
residing103015473res_iding
resighting1546073resighting
resigning1139463resigning
resiling93520173res_iling
resinating11313733resinating
resining92919553res_ining
resittings11264553resittings
resizing182714163res_izing
resmelting1337263resmelting
resmoothing17122593resmoothing
resoften1145443resoften_
resoftening1543233resoftening
resoftens1243713resoftens
resorcinol12122113resorcinol
resorption1247253resorption
resorptions1347233resorptions
resorptive1544763resorptive
resort65728623resort___
resorted9313493resort_ed
resorter8312183resort_er
resorters939693resorters
resorts74817193resort__s
resounding1236363resounding
respacing1438893respacing
respading1338803respading
respecting1549883respecting
respiring12159903respiring
responding1437403responding
respooling1355743respooling
resprang11175843respr_ang
respraying1636093respraying
resprings12156253respr_ings
resprouting1445053resprouting
resprung11164103respr_ung
restaging112410853restaging
restocking1745703restocking
restoking1438193restoking
restrain8311703restrain_
restrains9311623restrains
restraint9412753restraint
restricting1449303restricting
restriking1548043restriking
restrings10159293restr_ings
restriving1448133restriving
restrung9176443restr_ung
restyling1337923restyling
resuming11310083res_uming
retarding111110653retarding
retasting102513413retasting
retesting102614603retesting
retinting102215253retinting
retiring92717413retir_ing
retooling1039093retooling
retortion949673retortion
retortions1049143retortions
retrying122410453re_trying
retting83425883re__tting
returning1038133returning
reuniting10310693reuniting
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
revesting132814123revesting
revetting132912633revetting
revoicing15117713revoicing
revoking1637803revo_king
revolving1635843revolving
rewarding14148833rewarding
rewarming15147383rewarming
rewetting132710443rewetting
rewiring122911223rewir_ing
rewriting13310413rewriting
rezeroing1935933rezeroing
rezoning18310453rezo_ning
rioting82716393r_io_ting
riposting1236063riposting
ripsnorting1451533ripsnorting
roosting93411463r_oosting
rooting83522433r__ooting
rotting82919683r__otting
routing83821093r__outing
rumoring1136983rumor_ing
russeting1065323russeting
rusting83821263rus__ting
shorting122514803_shorting
snorting92613373_snorting
sooting82820963__sooting
sorbing102815263__sorbing
soring74731883__sor_ing
sorning83116813__sorning
sporting112415463_sporting
testing86021053tes__ting
vesting114618683ves__ting
visoring1238373visor_ing
westing115020273wes__ting
wresting123811833wres__ting
zesting174515333zes__ting

Search took 9 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.436409841.7
2DLD Change Limit1486413567.92318760.7
3Display Results3563560.1732057.8
 (SQL Overall)1786913568.53220943.6
 
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.