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

344 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
resisting10321531(None) 
desisting112810381desisting
relisting102414351relisting
resifting133512091resifting
resiting93521121resi_ting
resitting103414871resitting
assisting1046182assisting
bemisting1438072bemisting
delisting112710502delisting
existing1639072_existing
heisting123411042he_isting
insisting1038822insisting
persisting1346652persisting
presifting1638082presifting
recasting122414232recasting
reciting113118072reci_ting
reesting93118272re_esting
refitting132811122refitting
reissuing1034612reissuing
relishing13229182relishing
reminting122315102reminting
remising112516452remis_ing
remitting122412622remitting
renesting102514702renesting
repasting122312842repasting
rerising93017782reris_ing
reseating102421532reseating
resecting122816482resecting
resenting102619292resenting
resetting102816292resetting
residing103015472resi_ding
resighting1546072resighting
resigning1139462resigning
resiling93520172resi_ling
resinating11313732resinating
resining92919552resi_ning
resistant948612resistant
resistive1247582resistive
resittings11264552resittings
resizing182714162resi_zing
reslating102516992reslating
resorting10614612resorting
respiting121912862respiting
restating102319412restating
resting85031182re__sting
resulting10311082resulting
retasting102513412retasting
retesting102614602retesting
retinting102215252retinting
retwisting1445632retwisting
revesting132814122revesting
revising122714402revis_ing
revisiting1446952revisiting
agisting1038243_agisting
befitting15236623befitting
bekissing1643503bekissing
besetting12268423besetting
besieging1344763besieging
besotting12256873besotting
besting104923923be__sting
breasting1239583bre_asting
cessing103814813ces_s_ing
coexisting2044403coexisting
consisting1349523consisting
crediting1338843credi_ting
cresting114017043cre__sting
debiting122511203debi_ting
degusting1236163degusting
dehiscing1643733dehiscing
demasting1338453demasting
demising122012523demis_ing
demitting13239073demitting
depicting1537813depicting
desalting1138843desalting
deserting11713143deserting
designing1236623designing
desiring10312143desi_ring
despising13167503despis_ing
despiting13179323despiting
detesting112610323detesting
devesting14249903devesting
deviating14311083deviating
devising133111523devis_ing
dressing102810423dres_s_ing
easting84924303_e_asting
editing9313133_edi_ting
egesting1039013_egesting
emitting112410353_emitting
enisling949633_enisling
enlisting1038343enlisting
escoting1158713_escoting
estating92614993_estating
evicting1437483_evicting
eviting11511373_evi_ting
exiting15311393_exi_ting
feasting122011323fe_asting
feinting123410833fe_inting
fessing113812863fes_s_ing
fisting113818123__fisting
foisting122910503_foisting
gestating11229983gestating
hesitating1448003hesitating
histing113720373__histing
hoisting123610903_hoisting
jessing153710623jes_s_ing
jesting154317713je__sting
joisting16328503_joisting
leniting9312353leni_ting
lesioning1046443lesioning
listing84020593__listing
mediating13311203mediating
meriting11314683meri_ting
messing103916393mes_s_ing
misting103623383__misting
nesting84320443ne__sting
peising103416763pe_is_ing
perishing1539533perishing
positing11312303posi_ting
precasting15169833precasting
precising14413273precis_ing
predicting1649873predicting
preexisting2144223preexisting
premising14412413premis_ing
prepasting15168883prepasting
presenting131013023presenting
presetting131010833presetting
presiding13510903presi_ding
presorting1339983presorting
pressing112516443pres_s_ing
pretasting13239283pretasting
pretesting131810683pretesting
prevising15510873previs_ing
previsiting1745543previsiting
radiating111112133radiating
raising83220533r_ais_ing
rassling939013ras_sling
ravishing1634983ravishing
reacting113317893re_acting
realising10313173realis_ing
rebaiting12311643rebaiting
rebating112418343re_bating
rebidding14275463rebidding
rebilling12228833rebilling
rebinding13249483rebinding
rebooting12139023rebooting
rebutting1237523rebutting
recanting122414823recanting
receipting1546753receipting
recessing12611013recessing
recoating121317463recoating
recrating121318793recrating
recusing112512883recus_ing
recutting1239483recutting
redacting13612303redacting
redating102620173re_dating
redialing11311843redialing
redigesting1444573redigesting
redipping1555593redipping
redistill1044503redistill
redshirting1643263redshirting
reediting11310953reediting
reemitting1346633reemitting
reenlisting1244673reenlisting
refecting152413353refecting
refighting1845203refighting
refiling123116533refi_ling
refilling13299333refilling
refilming15256463refilming
refinding14259943refinding
refining122416863refi_ning
refiring123513923refi_ring
refixing19329793refi_xing
reflating132514713reflating
refusing122310873refus_ing
refuting121911903re_futing
regilding1236123regilding
registering1346393registering
regiving13269713regi_ving
regrating111316213regrating
rehashing1647113rehashing
reheating132314913reheating
rehinging1437453rehinging
rehiring122911883rehi_ring
reifying1539383re_ifying
reigning1039883re_igning
reining84425323re_i_ning
reinking13311023re_inking
reiving113316843re_i_ving
rejecting192211153rejecting
rejigging1933923rejigging
reknitting1584993reknitting
relating92725443re_lating
relenting102716773relenting
reletting102713943reletting
relieving1336693relieving
relighting1545853relighting
relining93218743reli_ning
relinking1458253relinking
reliving122713343reli_ving
relucting1239773relucting
remating112322423re_mating
remeeting12311433remeeting
remelting12311703remelting
reminding132311543reminding
remixing182810333remi_xing
renigging1235573renigging
renting84026853re__nting
reoiling93217213reoi_ling
repainting13128973repainting
repassing12249423repassing
repeating122618983repeating
repenting122316553repenting
repining114116593repi_ning
repinning12258973repinning
replating122217403replating
reporting12513903reporting
reposing111213803repos_ing
repositing13310493repositing
repotting12511123repotting
reprinting131510583reprinting
reprising12312553repris_ing
reputing112412603re_puting
requesting2046313requesting
requiting1939883requiting
reraising10313773rerais_ing
rerenting102617663rerenting
rerigging1236553rerigging
rerouting10311873rerouting
resailing103314253resailing
resaluting1137393resaluting
resawing122311433res_awing
resaying122512453res_aying
rescaling122212013rescaling
rescinding1436723rescinding
rescoring12310603rescoring
rescuing1139623res_cuing
resealing102115673resealing
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reseizing19311233reseizing
reselling102213833reselling
resending112313363resending
reserving131110643reserving
resettling1135893resettling
resewing122712263res_ewing
reshaping1557743reshaping
reshaving1657273reshaving
reshining13310743reshining
reshipping1843793reshipping
reshoeing1336593reshoeing
reshooting1436223reshooting
reshowing1646633reshowing
resilin72913973resi_lin_
resilins83013373resi_lins
resist64524533resist___
resistance1245883resistance
resistants1045523resistants
resisted9312693resist_ed
resister8311653resist_er
resisters9310453resisters
resistible1244613resistible
resistor847673resist_or
resistors947993resistors
resists74414923resist__s
resituating1247543resituating
resmelting1337263resmelting
resoaking1439373resoaking
resodding1237203resodding
resoling92916303res_oling
resolving1337743resolving
resonating11311263resonating
resorbing1269353resorbing
resowing123111523res_owing
respacing1438893respacing
respading1338803respading
respecting1549883respecting
respiring12159903respiring
resplitting1444943resplitting
respotting1347113respotting
respring111614063res_pring
restaging112410853restaging
restarting11310663restarting
restituting12156563restituting
restoking1438193restoking
restoring10314613restoring
restricting1449303restricting
restring91518783res_tring
restyling1337923restyling
resuming11310083res_uming
resurging1138613resurging
retieing92913713reti_eing
retiling93319483reti_ling
retiming113014193reti_ming
retiring92717413reti_ring
retitling1039773retitling
retorting10613273retorting
retting83425883re__tting
reuniting10310693reuniting
reusing82516783re_us_ing
reverting132315133reverting
revetting132912633revetting
reviewing1635513reviewing
reviling122917213revi_ling
reviving152910503revi_ving
revolting1339633revolting
revoting12312033re_voting
rewashing1676903rewashing
rewetting132710443rewetting
rewinding14238933rewinding
rewinning13257443rewinning
rewiring122911223rewi_ring
rewriting13310413rewriting
rifting113515003r__ifting
rioting82716393r__ioting
riposting1236063riposting
rising74025883r__is_ing
risking123914243r__isking
roasting93012703r_oasting
roosting93411463r_oosting
rosining92411423rosi_ning
rousting93913273r_ousting
russeting1065323russeting
rusting83821263r__usting
seising84018863se_is_ing
seriating10916403seriating
sifting113014593__sifting
silting83320483__silting
siting74126623__si_ting
sitting83519633__sitting
subsisting1345533subsisting
testing86021053te__sting
twisting12427813_twisting
vesicating1646903vesicating
vesting114618683ve__sting
visiting1238393visi_ting
waisting123615213_waisting
westing115020273we__sting
whisting15329543_whisting
wisting113519743__wisting
wresting123811833wre__sting
yeasting12188923ye_asting
yessing113210063yes_s_ing
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 Limit1486413447.42020032.5
3Display Results3443440.1562205.1
 (SQL Overall)1786913448.01622291.8
 
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.