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

240 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
spicated1330990(None) 
spicate113214191spicate_
aspirated1247702aspirated
auspicated1544302auspicated
epilated11310752epilated
opiated1039482opi_ated
picoted1239212_picoted
picrated132110112_picrated
pirated102515612_pirated
plicated13310642plicated
sonicated1248452sonicated
speciated14207542speciated
spectated14236592spectated
spicae104313702spica_e_
spiced115218312spic__ed
spinate93114812spinate_
spiraled1137722spiraled
spirited1148962spirited
spirted103913072spi_rted
spited94820442spi__ted
spitted103912702spi_tted
sulcated11310372sulcated
supinated1237872supinated
abdicated1547013abdicated
agitated1038413agitated
animated111612373animated
asperated1239313asperated
aspirate1039943aspirate_
aspirates1139613aspirates
auspicate1345743auspicate_
auspicates1444913auspicates
aviated11310263avi_ated
baccated15148373baccated
busticated1545723busticated
capitated14159043capitated
chicaned1665873chicaned
dedicated14310253dedicated
depicted1437743depic_ted
depilated1339653depilated
dictated1239203_dictated
dilated93115823_dilated
duplicated1655833duplicated
educated1237943educated
elicited1139093elicited
epilate9314283epilate_
epilates10313503epilates
estimated12109443estimated
estivated13108323estivated
evicted1337243evic_ted
expiated18168523expi_ated
explicated22106103explicated
falcated1438473falcated
fixated1835533_fixated
furcated1437593furcated
imitated1138263imitated
implicated1745973implicated
indicated13310953indicated
lapidated1345673lapidated
lichted13268803_lichted
ligated92414133_ligated
located103114183_located
loricated1247893loricated
masticated1548233masticated
medicated15410073medicated
muricated1448243muricated
nictated1137793_nictated
nidated939863_nidated
operated11512223operated
opiate8513463opi_ate_
opiates9312143opi_ates
oppilated1444583oppilated
oxidated1745033oxidated
pated85237843_p__ated
picante11310523_picante_
pickaxed2443513_pickaxed
picked154421313_pic_ked
picketed17167383_picketed
pickled164011883_pickled
picotee11311473_picotee
picrate112014143_picrate_
picrates122013203_picrates
pileated112711133_pileated
piloted10310323_piloted
pinnated11338553_pinnated
pirate82322883_pirate_
pirates93020323_pirates
pitted94319593_pi_tted
pivoted1336513_pivoted
placated1338453placated
plated95225773_p_lated
pleated103816633_pleated
plicate11314513plicate_
prated94924923_p_rated
pupated12319353_pupated
radicated13410123radicated
replicated1548773replicated
ruinated939523ruinated
rusticated1346983rusticated
saccate111311763saccate_
sainted84114243sai_nted
salivated1337473salivated
sanitated1068993sanitated
saponated1245733saponated
sated66238533s___ated
satiated9311603satiated
scaled94822443s__caled
scanted104114393s__canted
scaped115519553s__caped
scared95227293s__cared
scarted104816123s__carted
scathed134012643s__cathed
scatted103512773s__catted
seated75131053s__eated
sedated93714343s_edated
sensated938183sensated
separated1237713separated
seriated92717023seriated
serrated92513423serrated
shifted14359973shi_fted
shitted114212043shi_tted
sibilated1246713sibilated
sicced11489653s_ic_ced
sickbed16396823s_ickbed
sicked134524403s_ic_ked
sickled144713433s_ickled
sifted104313673s_i_fted
sighted123111523s_ighted
silicate10312623silicate_
silicates11311523silicates
silted74020013s_i_lted
sinuated938403sinuated
sited65130743s_i__ted
situated938023situated
skated114414873s__kated
skirted12388613ski_rted
skited114313473ski__ted
slated75028313s__lated
sliced94416313slic__ed
slicked144413843slic_ked
slighted1357393slighted
slipcased1462623slipcased
slitted83513313sli_tted
snicked143811633snic_ked
solated83618023s_olated
solicited1247963solicited
solvated12237443solvated
sonicate10310933sonicate_
sonicates11410383sonicates
sopited104211053sopi__ted
spaced114517253sp__aced
spackled17297793spackled
spaded103816753sp__aded
spaed85522273sp__a_ed
spared95427483sp__ared
spate74731583sp__ate_
spates85028173sp__ates
spathed134013183sp__athed
spatted104014143sp_atted
spayed124213613sp__ayed
speaned103411523sp_eaned
speared104314423sp_eared
specced14266703spec_ced
speciate12209583speciate_
speciates13229233speciates
specked16329013spec_ked
speckled17255823speckled
spectate12248833spectate_
spectates13228813spectates
specter113111733spec_ter
speculated15186613speculated
spica94717943spica___
spicas104715823spica__s
spiccato1463183spiccat_o
spiccatos1553253spiccatos
spice95528813spic__e_
spicer104719313spic__er
spices104326033spic__es
spicey134414233spic__ey
spicier115112463spic_ier
spiculate132210163spiculate_
spicule11269933spicule_
spicules12219803spicules
spied85427713spi___ed
spieled104811883spi_eled
spiered104412463spi_ered
spiffed16257103spi_ffed
spiffied17234823spiffied
spiked134915553spi__ked
spiled94621993spi__led
spilled103613623spi_lled
spinage10289653spinage_
spinages11289293spinages
spindled12287643spindled
spined95423943spi__ned
spinster1036683spinster
spiraea9407983spira_ea
spiralled1244393spiralled
spired94921863spi__red
spite75430663spi__te_
spites84127333spi__tes
spitter94015183spi_tter
splatted11356743splatted
splayed13357813sp_layed
spliced124310593splic__ed
splinted11369253splinted
spoliated1246913spoliated
sported104015433sp_orted
spotted103713133sp_otted
spouted103412263sp_outed
sprayed13398903sp_rayed
sprinted113411163sprinted
sprouted1136383sprouted
spurted103111973sp_urted
stated75427833s__tated
sticked144114633stic_ked
stickled15298973stickled
stilted83511473sti_lted
stinted82914193sti_nted
striated93414153striated
sublated11311493sublated
suicided1246023suicided
suited74019423sui__ted
sulcate9314423sulcate_
sulfated1238833sulfated
summated13298833summated
supinate10310313supinate_
supinates1139553supinates
supplicated1843723supplicated
suricate10312613suricate_
suricates11311733suricates
sweated113411543s_weated
syndicated1743743syndicated
tunicated12257493tunicated
updated11369423up_dated
uprated103213323up_rated
upscaled13144873upscaled
urinated9311613urinated
urticated1247693urticated
vacated1349353_vacated
vesicated15117653vesicated

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.1531167915.0
2DLD Change Limit1461622408.44017317.8
3Display Results2402400.0932580.6
 (SQL Overall)1786912408.68620572.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.