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

347 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
repasting12231284(None) 
prepasting15168881prepasting
recasting122414231recasting
repassing12249421repassing
retasting102513411retasting
breasting1239582bre_asting
demasting1338452demasting
departing1349512departing
easting84924302_e_asting
feasting122011322fe_asting
impasting1436322impasting
pasting103826552__pasting
precasting15169832precasting
pretasting13239282pretasting
reacting113317892re_acting
rebaiting12311642rebaiting
rebating112418342reba_ting
recanting122414822recanting
redacting13612302redacting
redating102620172reda_ting
reesting93118272re_esting
rehashing1647112rehashing
relating92725442rela_ting
relisting102414352relisting
remating112322412rema_ting
renesting102514702renesting
repacking1838282repacking
repainting13128972repainting
repairing12310012repairing
reparking1638922reparking
repaving142810742repa_ving
repaying142712392repa_ying
repeating122618982repeating
repenting122316552repenting
replanting1338522replanting
replating122217402replating
reporting12513902reporting
reposing111213802repos_ing
repositing13310492repositing
repotting12511122repotting
reputing112412602rep_uting
resisting103215312resisting
resting85031182re__sting
retesting102614602retesting
revesting132814122revesting
rewashing1676902rewashing
riposting1236062riposting
roasting93012702r_oasting
yeasting12188922ye_asting
aerating92821003aera_ting
basting104227203__basting
beastings12387653be_astings
beating104326873be_a_ting
bemisting1438073bemisting
bepainting15144883bepainting
berating113220763bera_ting
besting104923923be__sting
blasting114013433_blasting
boasting113512503_boasting
bypassing1742953bypassing
casting104628343__casting
ceasing104118263ce_as_ing
coasting113615513_coasting
creasing113314443cre_as_ing
creating113921953cre_a_ting
cremating14312193crema_ting
cresting114017043cre__sting
crevassing1643533crevassing
deashing134210953de_ashing
debasing12238063debas_ing
debating123213733deba_ting
decanting132510633decanting
defatting1436103defatting
degassing1234823degassing
degusting1236163degusting
delating103119603dela_ting
delisting112710503delisting
depainting14156153depainting
depicting1537813depicting
depleting1378193depleting
deporting1369593deporting
deposing12129773depos_ing
depositing1446933depositing
deputing12238793dep_uting
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desisting112810383desisting
detesting112610323detesting
devesting14249903devesting
easing74926463_e_as_ing
eastings93412953_e_astings
eating75134403_e_a_ting
egesting1039013_egesting
elastin72611843_elastin_
elastins82111743_elastins
elating83423083_ela_ting
enacting11311363_enacting
erasing8317963_eras_ing
exacting1838523_exacting
exalting1638033_exalting
existing1639073_existing
fasting114522833__fasting
feasing113916653fe_as_ing
forecasting1744473forecasting
foretasting1554423foretasting
gasting95022763__gasting
gelating103015733gela_ting
greasing102811393gre_as_ing
hasting114725193__hasting
hearting12513123he_arting
heating114024323he_a_ting
heisting123411043he_isting
impacting1635943impacting
imparting1437243imparting
imposting1436813imposting
jesting154317713je__sting
lasting84725243__lasting
leashing123310313le_ashing
leasing83920163le_as_ing
legating102313113lega_ting
levanting1345523levanting
masting104325823__masting
negating102012833nega_ting
nesting84320443ne__sting
panting104025423__panting
parting103527383__parting
pashing135120513__pashing
passing104318423__passing
pastina93914593__pastina
patting103722343__patting
posting105622243__posting
preacting142412533pre_acting
predating13514653preda_ting
prepacking2145773prepacking
preparing14311643prepa_ring
prepaving1787233prepa_ving
prepaying1747973prepa_ying
preplanting1645933preplanting
pretesting131810683pretesting
prewashing1944943prewashing
pupating1337683pupa_ting
rafting113815753r__afting
ramparting1543893ramparting
ranting84025413r__anting
rasing74330833r__as_ing
rasping104316253r__asping
rating74938703r__a_ting
ratting83822363r__atting
reaching143317203re_aching
readapting1445153readapting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
reaming103924013re_a_ming
reaping103621213re_a_ping
rearing83128783re_a_ring
rearming111413613re_arming
reasoning10310203re_asoning
reassign955423re_assign
reaving113820533re_a_ving
rebooting12139023rebooting
rebutting1237523rebutting
recalling122211903recalling
recaning111416693reca_ning
recapping1636453recapping
recessing12611013recessing
recharting1637213recharting
reciting113118073re_citing
reclasping15105083reclasping
recoating121317463recoating
recrating121318793recrating
recusing112512883recus_ing
recutting1239483recutting
redbaiting1446263redbaiting
redrafting1545963redrafting
reearning1039053reearning
reediting11310953reediting
reenacting1357353reenacting
refacing142512813refa_cing
refalling132010423refalling
refasten1136103refasten_
refastening1544303refastening
refastens1244753refastens
refecting152413353refecting
refitting132811123refitting
reflating132514713reflating
refracting1638733refracting
refusing122310873refus_ing
refuting121911903re_futing
regaining112411083regaining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regrating
rehabbing1733653rehabbing
rehanging1437563rehanging
reheating132314913reheating
reissuing1034613reissuing
rejecting192211153rejecting
relacing112516043rela_cing
relanding112110923relanding
relapsing1236843relapsing
relaxing162612633rela_xing
relaying122515153rela_ying
releasing10411013releas_ing
relenting102716773relenting
reletting102713943reletting
relishing13229183relishing
relucting1239773relucting
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
remastering1446843remastering
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remising112516453remis_ing
remitting122412623remitting
renailing102813333renailing
renaming11313693rena_ming
renting84026853re__nting
repaint9318363repa__int
repaneling1345733repaneling
repapering1547043repapering
repast83520633repast___
repasted112611533repast_ed
repasts93611933repast__s
repatching1844993repatching
repealing122513543repealing
repegging1435593repegging
repelling122312753repelling
reperking1638703reperking
rephrasing1645643rephras_ing
repining114116593rep_ining
repinning12258973repinning
replacing142210163replacing
replanning1345313replanning
replastering1553413replastering
replaying15259603replaying
replotting1357043replotting
replowing1537413replowing
replying14269403rep_lying
repolling122110203repolling
repouring12310073repouring
repping123314983rep__ping
repressing13310393repressing
repricing14310473repricing
reprinting131510583reprinting
reprising12312553reprising
reprobing1438073reprobing
reproving1538413reproving
repugning1335863repugning
repulsing1237613repulsing
repumping1634813repumping
repursuing1343013repursuing
requesting2046313requesting
requiting1939883requiting
reracking1639313reracking
reraising10313773reraising
rerenting102617663rerenting
rerising93017783reris_ing
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433resa_wing
resaying122512453resa_ying
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
resifting133512093resifting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resorting10614613resorting
respacing1438893respa_cing
respading1338803respa_ding
respecting1549883respecting
respiting121912863respiting
respotting1347113respotting
restarting11310663restarting
restating102319413restating
restring91518783re__string
resulting10311083resulting
retacking1658973retacking
retagging1236033retagging
retailing103214733retailing
retaining102114733retaining
retaking133114283reta_king
retaping113012553reta_ping
retarding111110653retarding
retaxing162311333reta_xing
retinting102215253retinting
retorting10613273retorting
retracting13311933retracting
retting83425883re__tting
retwisting1445633retwisting
reuniting10310693reuniting
reusing82516783re_us_ing
revaluing1337303revaluing
revamping1734633revamping
reverting132315133reverting
revetting132912633revetting
revising122714403revis_ing
revisiting1446953revisiting
revolting1339633revolting
revoting12312033re_voting
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewaxing19248563rewa_xing
rewetting132710443rewetting
rewriting13310413rewriting
ripsawing1542873ripsawing
roosting93411463r_oosting
rotating92614553rota_ting
rousting93913273r_ousting
rusting83821263r__usting
seating84130683se_a_ting
sedating103014113seda_ting
sensating1039253sensating
separating1348643separating
spasming13227203_spasming
spatting113111763_spatting
tasting84624213__tasting
teasing83918513te_as_ing
tempesting1544453tempesting
tenanting1036213tenanting
testing86021053te__sting
toasting93410583_toasting
treating92519613tre_a_ting
trepanning1344153trepanning
trespassing1442313trespassing
upcasting1434823upcasting
vesting114618683ve__sting
wasting114422843__wasting
webcasting1842483webcasting
westing115020273we__sting
wresting123811833wre__sting
zesting174515333ze__sting

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.440406115.9
2DLD Change Limit1486413477.42020032.5
3Display Results3473470.1402478.6
 (SQL Overall)1786913478.00022336.4
 
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.