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

361 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
recasting12241423(None) 
precasting15169831precasting
recanting122414821recanting
repasting122312841repasting
retasting102513411retasting
breasting1239582bre_asting
casting104628342__casting
decanting132510632decanting
demasting1338452demasting
easting84924302_e_asting
feasting122011322fe_asting
forecasting1744472forecasting
prepasting15168882prepasting
pretasting13239282pretasting
reacting113317892re_acting
rebaiting12311642rebaiting
rebating112418342reba_ting
recalling122211902recalling
recaning111416692reca_ning
recapping1636452recapping
recessing12611012recessing
recharting1637212recharting
reciting113118072rec_iting
reclasping15105082reclasping
recoating121317462recoating
recrating121318792recrating
recusing112512882recus_ing
recutting1239482recutting
redacting13612302redacting
redating102620172reda_ting
reesting93118272re_esting
rehashing1647112rehashing
relating92725442rela_ting
relisting102414352relisting
remating112322412rema_ting
renesting102514702renesting
repassing12249422repassing
resisting103215312resisting
resting85031182re__sting
retesting102614602retesting
revesting132814122revesting
rewashing1676902rewashing
roasting93012702r_oasting
upcasting1434822upcasting
webcasting1842482webcasting
yeasting12188922ye_asting
accosting1446733accosting
aerating92821003aera_ting
basting104227203__basting
beastings12387653be_astings
beating104326873be_a_ting
becalming1635283becalming
becapping1834243becapping
beclasping17134073beclasping
becrusting1544603becrusting
bemisting1438073bemisting
berating113220763bera_ting
besting104923923be__sting
blasting114013433_blasting
boasting113512503_boasting
canting104725903__canting
carting104228283__carting
cashing135022553__cashing
casing94829103__cas_ing
casking144317353__casking
castings113614053__castings
castling11311233__castling
catting103922643__catting
ceasing104118263ce_as_ing
coasting113615513_coasting
costing104323023__costing
creasing113314443cre_as_ing
creating113921953cre_a_ting
cremating14312193crema_ting
cresting114017043cre__sting
crevassing1643533crevassing
deashing134210953de_ashing
debasing12238063debas_ing
debating123213733deba_ting
decamping1734943decamping
decaying15239453deca_ying
deceasing1338403deceas_ing
declassing1445123declassing
decocting1538123decocting
defatting1436103defatting
degassing1234823degassing
degusting1236163degusting
delating103119603dela_ting
delisting112710503delisting
departing1349513departing
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
descanting1446923descanting
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
encashing1536443encashing
encasing11610823encas_ing
encysting1544613encysting
erasing8317963_eras_ing
erecting112415063erec__ting
exacting1838523_exacting
exalting1638033_exalting
existing1639073_existing
fasting114522833__fasting
feasing113916653fe_as_ing
foretasting1554423foretasting
gasting95022763__gasting
gelating103015733gela_ting
greasing102811393gre_as_ing
hasting114725193__hasting
hearting12513123he_arting
heating114024323he_a_ting
heisting123411043he_isting
impasting1436323impasting
incanting1289903incanting
incasing11610603incas_ing
jesting154317713je__sting
lasting84725243__lasting
leashing123310313le_ashing
leasing83920163le_as_ing
legating102313113lega_ting
levanting1345523levanting
linecasting14102783linecasting
locating11311503loca_ting
masting104325823__masting
miscasting1557073miscasting
negating102012833nega_ting
nesting84320443ne__sting
overcasting1748513overcasting
pasting103826553__pasting
preacting142412533pre_acting
precenting151012153precenting
precessing1598743precessing
precising14413273precis_ing
precutting1546423precutting
predating13514653preda_ting
pretesting131810683pretesting
prewashing1944943prewashing
racheting1537793racheting
racketing1647873racketing
rafting113815753r__afting
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
recapturing1643763recapturing
recarpeting1674363recarpeting
recarrying1643653recarrying
recast83422773recast___
recasts93413533recast__s
recaution1148093recaution
recautions1247813recautions
receding122713763rec_eding
receipting1546753receipting
receiving1538993receiving
rechanging1746043rechanging
recharging1745293recharging
rechewing1836493rechewing
recking144319923rec__king
reckoning1637643reckoning
recladding1543973recladding
reclaiming1546583reclaiming
reclining121112283reclining
reclothing1644973reclothing
recoaling121312453recoaling
recocking18138373recocking
recoding122213853rec_oding
recoiling121412413recoiling
recoining121313803recoining
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recounting1339193recounting
recouping1438363recouping
recreating131214583recreating
recrossing1386973recrossing
recruiting1347903recruiting
recurring1237953recurring
recurving1536773recurving
recycling1734903recycling
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
relocating13310873reloca_ting
relucting1239773relucting
remailing122412473remailing
remaining122212793remaining
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
remastering1446843remastering
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remising112516453remis_ing
remitting122412623remitting
renailing102813333renailing
renaming11313693rena_ming
renting84026853re__nting
repacking1838283repacking
repainting13128973repainting
repairing12310013repairing
reparking1638923reparking
repaving142810743repa_ving
repaying142712393repa_ying
repeating122618983repeating
repenting122316553repenting
replanting1338523replanting
replating122217403replating
reporting12513903reporting
reposing111213803repos_ing
repositing13310493repositing
repotting12511123repotting
reputing112412603re_puting
requesting2046313requesting
requiting1939883requiting
reracking1639313reracking
reraising10313773reraising
rerenting102617663rerenting
rerising93017783reris_ing
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433resa_wing
resaying122512453resa_ying
rescaling122212013resca_ling
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
resifting133512093resifting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resorting10614613resorting
respiting121912863respiting
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
riposting1236063riposting
rocketing1666973rocketing
roosting93411463r_oosting
rotating92614553rota_ting
rousting93913273r_ousting
rusting83821263r__usting
scanting113914763_scanting
scarting113415263_scarting
scatting113311813_scatting
seating84130683se_a_ting
secreting1279823secreting
sedating103014113seda_ting
sensating1039253sensating
tasting84624213__tasting
teasing83918513te_as_ing
telecasting1443793telecasting
tenanting1036213tenanting
testing86021053te__sting
toasting93410583_toasting
treating92519613tre_a_ting
typecasting1951963typecasting
uncasing11511003uncas_ing
vacating14310353vaca_ting
vesting114618683ve__sting
wasting114422843__wasting
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.783228213.3
2DLD Change Limit1486413617.98318619.7
3Display Results3613610.1562314.1
 (SQL Overall)1786913618.92220028.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.