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

218 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
spirited114897(None) 
spirted103913071spir_ted
aspirated1247702aspirated
dispirited1445932dispirited
inspirited1343702inspirited
pirated102515612_pirated
skirted12388612skir_ted
spicated13309902spicated
spiraled1137732spiraled
spired94921862spir__ed
spirier93214072spiri_er
spirit83519922spirit__
spiritedly1652712spiritedly
spirits94112622spirit_s
spirituel1143212spirituel
spited94820442sp__ited
spitted103912702spi_tted
sported104015432spor_ted
sprinted113411162sprinted
sprite84421772sp_rite_
sprites94220332sp_rites
spritzed2044802sp_ritzed
spurted103111972spur_ted
airted74214503_air_ted
apprised1337713apprised
apprized2236543apprized
asperated1239313asperated
aspirate1039943aspirate_
aspirates1139613aspirates
aspired1068173aspir__ed
attrited947373attrited
dirtied93210853_dirtied
elicited1139093elicited
epilated11310753epilated
flirted11428673flir_ted
girted83912873_gir_ted
irised73913153__irised
limited102310233_limited
merited10313853_merited
operated11512223operated
opiated1039483opi_ated
parted94228683_par_ted
partied103516553_partied
periled10316323_periled
picoted1239213_picoted
picrated132110113_picrated
picrite111911313_picrite_
picrites121811083_picrites
piloted10310323_piloted
pinite8321243_pinite_
pinites9319533_pinites
pirate82322883_pirate_
pirates93020333_pirates
pitied94017253_piti_ed
pitted94319593_pi_tted
pivoted1336513_pivoted
plaited103713893_plaited
ported94223243_por_ted
posited10511493_posited
prated94924923_p_rated
priced115018883_p_riced
prided103618033_p_rided
pried84426863_p_ri_ed
primed115118913_p_rimed
printed104016373_printed
prised94322203_p_rised
prized184415393_p_rized
pyrite11913313_pyrite_
pyrites12812203_pyrites
quirted17369213quir_ted
sainted84114243sai_nted
satirised1046553satirised
satirized1957893satirized
scarted104816123scar_ted
scimiter1236143scimiter
scribed124510643s_cribed
scried95817303s_cri_ed
scripted13117553scripted
scrived134511113s_crived
secreted1138633secreted
separated1237713separated
seriated92717023seriated
serifed11811463s_erifed
serrated92513433serrated
serried82513963serri_ed
shifted14359983shi_fted
shirked153710463shir_ked
shirred113710503shir_red
shirtier1137943shirtier
shitted114212053shi_tted
shorted113614403shor_ted
shrined114112413s_hrined
shrived144712183s_hrived
sifted104313673s_i_fted
sighted123111523s_ighted
silted74020013s_i_lted
sired66134283s_ir__ed
siruped1036013s_iruped
sited65130743s___ited
skirled12348183skir_led
skirred12347083skir_red
skirter11338483skir_ter
skited114313483s__kited
slighted1357393slighted
slitted83513313sli_tted
smarted105012613smar_ted
smirched1634673smirched
smirked14307233smir_ked
snorted83813493snor_ted
solicited1247973solicited
sopited104211063s_opited
sorites73825243s_orites
sorted74523713s_or_ted
sortied83314103s_ortied
spared95427493spar__ed
sparged113512763spar_ged
sparid94016933spari__d
sparked143513143spar_ked
sparkled15317733sparkled
sparred104512863spar_red
spatted104014143sp_atted
spavined1434333spavined
speciated14207543speciated
speiled104412123sp_eiled
speired103811103sp_eired
spicate113214193spicate_
spiced115218313sp__iced
spicier115112463spici_er
spied85427713sp__i_ed
spieled104811883spi_eled
spiered104412463spi_ered
spiffed16257103spi_ffed
spiffied17234823spiffied
spiked134915553sp__iked
spikier13369983spiki_er
spiled94621993sp__iled
spilled103613623spi_lled
spinate93114813spinate_
spindled12287643spindled
spined95423943sp__ined
spinier93715163spini_er
spinifex2042053spinifex
spinster1036683spinster
spiraea9407983spir_aea
spiralled1244403spiralled
spire75828693spir__e_
spirea84015633spir__ea
spirem104214163spir__em
spireme11478363spireme_
spiremes12397623spiremes
spires84628113spir__es
spiriest102513463spiriest
spirilla1045073spirilla
spiring103918183spiri_ng
spiriting1238413spiriting
spiritism1345553spiritism
spiritist1148093spiritist
spiritless1243743spiritless
spiritoso1142283spiritoso
spiritous1155023spiritous
spiritual1144253spiritual
spiroid10219823spir_oid
spirt75032953spir_t__
spirting112913633spirting
spirts85317133spir_t_s
spite75430663sp__ite_
spites84127333sp__ites
spitter94015183spi_tter
splatted11356743splatted
spliced124310593sp_liced
splined105013113sp_lined
splinted11369253splinted
spoiled104811353sp_oiled
spoliated1246913spoliated
spored94821793spor__ed
sporter93616553spor_ter
sportier102010053sportier
spotted103713143sp_otted
spouted103412263sp_outed
sprained1138433sprained
sprayed13398903sp_rayed
sprier84119063sp_ri_er
sprigged13316223sprigged
springed123911323springed
sprinter103810813sprinter
sprit76736403sp_rit__
sprits85122533sp_rit_s
spritz174714423sp_rit_z
spritzer1944563sp_ritzer
spritzes1946943sp_ritzes
sprouted1136393sprouted
spruced12307533sp_ruced
spurned10339263spur_ned
spurred103610623spur_red
spurter94013003spur_ter
squirted1845793squir_ted
started84217323star_ted
stilted83511473sti_lted
stimied10310623stimi_ed
stinted82914193sti_nted
stipites1039653stipites
stirred8359703stir_red
storied8515163stori_ed
striated93414153striated
striped105214363s_triped
strived114713663s_trived
suicided1246033suicided
suited74019423s__uited
summited13246413summited
supinated1237883supinated
swirled11308223swir_led
thirsted1235213thirsted
updried11226473updri_ed
uprated103213323up_rated
visited1168773_visited
worrited1235743worrited
yperite1249893yperite_
yperites13310153yperites

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 Filter1786911461620.563317390.8
2DLD Change Limit1461622188.04618165.8
3Display Results2182180.0802725.0
 (SQL Overall)1786912188.68920565.2
 
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.