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

188 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
sporoid10231072(None) 
sparoid102311531sparoid
spiroid10219821spiroid
choroid13311792choroid
sordid83411152s_ordid
sparid94016932spar_id
sparoids11218712sparoids
spheroid1447282spheroid
spoored104411292spoored
spored94821792spor_ed
sported104015432sported
sportif1238792sportif
steroid81314852steroid
toroid7416012_toroid
acaroid103512303acaroid
ambroid1238863ambroid
android9311503android
aneroid8313983aneroid
aporia8315863apor_ia
aroid65428333__aroid
asteroid9511173asteroid
choreoid1447923choreoid
chorioid1448323chorioid
choroids1438683choroids
conoid9818883_conoid
cormoid12310403_cormoid
corvid12310473_corvid
droid74218533__droid
emeroid101511173emeroid
fibroid1337243fibroid
florid10311453flor_id
forbid123312433_forbid
fordid113512053_fordid
globoid1145963globoid
horrid10311553_horrid
hydroid1539703hydroid
labroid1038823labroid
leporid1048153lepor_id
morbid112511463_morbid
negroid9108883negroid
neuroid81110303neuroid
obovoid1342783obovoid
ochroid1357903ochroid
opioid9310083op_ioid
oroide7311703__oroide
ovoid94811023__ovoid
parotid102915503_parotid
percoid12312313_percoid
period9314983_period
peroxid17310263_peroxid
phoronid1449073phoronid
pongid104111583_pongid
pood75934323_po_o_d
pooed85226243_po_oed
poori74816233_poori_
pooris83916843_pooris
pored85234513_por_ed
porked134717623_porked
porose84818743_porose
porous84419483_porous
ported94223243_ported
prod76129503_p_ro_d
proud84615483_p_roud
psocid1137253pso_cid
pyoid11513753_p_yoid
saporous1039053saporous
sarcoid10310453sarcoid
sarod65325873s_aro_d
schrod1247883schro_d
sciuroid1144403sciuroid
scleroid1147203scleroid
scombroid1652613scombroid
scored94621133scor_ed
scoria8513483scor_ia
scorned10229953scorned
scorpioid1443293scorpioid
scrod85115063s_cro_d
sepaloid1146753sepaloid
shooed103916073sho_oed
shored105723643shor_ed
shorted113614393shorted
shortia1048173shortia
shortie10411323shortie
shroud1038763s_hroud
sialoid8310953sialoid
sigmoid1146093sigmoid
siluroid945053siluroid
simioid1047993simioid
sistroid947253sistroid
sloid64619693s__loid
snood64616163sno_o_d
snored74819543snor_ed
snorted83813493snorted
solid65025073s_o_lid
soloed74515743s_oloed
sorbed94916513s_orbed
sorbic10310383s_orbic
sord56237203s_or__d
sored66141783s_or_ed
sori46039833s_or_i_
sorned74820043s_orned
sorosis72611963s_orosis
sorted74523713s_orted
sortie63621983s_ortie
sortied83314093s_ortied
spared95427483spar_ed
sparged113512753sparged
sparids103512123spar_ids
sparked143513133sparked
sparred104512853sparred
spermic1338523spermic
sphenoid1446323sphenoid
spheroids1545543spheroids
spired94921863spir_ed
spirit83519923spir_it
spirted103913073spirted
spoil75818643sp__oil
spoiled104811353spoiled
spoked134413893spo_ked
sponged1137953sponged
spongin1036363spongin
spoof105019013spo_o_f
spoofed13399103spoofed
spoofs114011813spo_ofs
spoofy14498553spo_ofy
spook115416043spo_o_k
spooked144510473spooked
spooks124312933spo_oks
spooky15418093spo_oky
spool75219043spo_o_l
spooled104613523spooled
spools85115913spo_ols
spoon74719443spo_o_n
spooned103412443spooned
spoons84116013spo_ons
spoony114111793spo_ony
spoor75016353spo_o_r
spooring113111463spooring
spoors84014023spo_ors
sporadic1345053sporadic
sporal82915453spor_al
spore75428593spor__e
spores84726613spor_es
sporicide1484793sporicide
sporing104319413sporing
sporozoa19103253sporozoa
sporozoic2262753sporozoic
sporran936743sporran
sport75935983spor__t
sporter93616553sporter
sportier102010053sportier
sportily1337733sportily
sporting112415463sporting
sportive1348333sportive
sports84619183spor_ts
sporty115112493spor_ty
sporule937273sporule
spotlit947283spotlit
spotted103713133spotted
spoused10349653spoused
spouted103412263spouted
sprain83614863sp_rain
spread9312533sp_read
sprig85617743sp_r_ig
sprit76736403sp_r_it
sprout8419403sp_rout
spurned10339263spurned
spurred103610613spurred
spurted103111973spurted
steroids9911433steroids
stolid74213173sto_lid
stood65517713sto_o_d
stored75524213stor_ed
storied8515163storied
stormed1039043stormed
stroud7310383s_troud
styloid1137543styloid
sword95214113swor__d
theroid11313393theroid
thyroid1438243thyroid
toroids8310643_toroids
torpid9310913_torpid
torrid7311853_torrid
toxoid1438153_toxoid
upbraid1244973upbraid
viroid10411523_viroid
zebroid1936463zebroid
zooid15312103_zo_oid

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271887.86017051.8
3Display Results1881880.0632984.1
 (SQL Overall)1786911888.07922118.0
 
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.