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

172 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
spelean93712(None) 
spelaean1043211spelaean
shebean1235762shebean
spean74620512sp__ean
spleen8310262sp_leen
abelian92810653abelian
amebean1144863amebean
aphelian1376963aphelian
apogean1045443apogean
avellan1037303avellan
beleap10410283_beleap
bemean10410683_bemean
capelan1139003capel_an
clean75420413__clean
delead84112343_delead
demean9510563_demean
elan46734243__el_an
epigean1045503epigean
glean65818203__glean
lean46345243___lean
melena81110473_melena
paean77222723_p_aean
palea75028663_palea_
paleae84820293_paleae
paleal84716673_paleal
pean66147173_p__ean
pecan91919033_pe_can
pechan13511543_pechan
peen65938083_pe_e_n
pekan111613973_pe_kan
pele65539553_pele__
peles75738083_pele_s
pelican1139433_pelican
pelon74423213_pel_on
penman10312323_penman
perea75026443_perea_
pereon83517453_pereon
pilea75123953_pilea_
plan65833943_p_l_an
plea66830603_p_lea_
plead85818463_p_lead
pleas75627033_p_leas
pleat74734473_p_leat
plena75816393_p_lena
pleon74216383_p_leon
poleax1547993_poleax
poleyn1157323_poleyn
preclean1245893preclean
quelea1547303quelea_
queleas1636723queleas
reclean938523reclean
relearn747973_relearn
reloan6415693_reloan
replan83215823repl_an
replead10399013replead
scalepan1244513scalepan
seaman84015903s_eaman
seawan94111223s_eawan
secern81010223s_ecern
sedan65620423s_e_dan
seedman1037373seedman
seeled73922093seele_d
seen46943123s_e_e_n
seitan62613233s_eitan
sejeant1489723s_ejeant
selah8319613s_el_ah
select82621173s_elect
selsyn983843s_elsyn
selva83014273s_elva_
selvas93812913s_elvas
semen75724103s_eme_n
serein63318463s_erein
seven84118313s_eve_n
sewan85921293s_e_wan
sextan13389643s_extan
shebeans1344703shebeans
shebeen1234553shebeen
sheen85023313she_e_n
sheitan1036573sheitan
shellac1236693shellac
shelta93111793shelta_
sheltas10279673sheltas
sierran737193sierran
silvan92810153s_ilvan
skean94415623s__kean
skeen94817403ske_e_n
skeletal1244043skeletal
skeleton1244473skeleton
solan55328153s_ol_an
soldan73511853s_oldan
solemn838643s_olemn
soybean1243953soybean
spaceman1445323spaceman
spaldeen1142773spaldeen
spale74929213spale__
spales84728103spale_s
spalpeen1252503spalpeen
span65234663sp___an
spartan948333spartan
speak114618673sp__eak
speans85417143sp__eans
spear75821063sp__ear
spearman1244943spearman
special11310303special
speech1347563spe_ech
speed85526623spe_e_d
speedo94011993spe_edo
speeds94316053spe_eds
speedy1218410793spe_edy
speel74420763spe_e_l
speeled103712453speeled
speeling112713123speeling
speels85116393spe_els
speer74623903spe_e_r
speers85019953spe_ers
speiled104412123speile_d
spell75020303spel__l
spelled103714743spelled
speller95415153speller
spellers102812763spellers
spelling113315233spelling
spells84617683spel_ls
spelt75430193spel__t
spelter94113703spelter
spelters103912243spelters
spelts84614643spel_ts
speltz174010123spel_tz
spelunk1343203spelunk
spewed125512333spewe_d
spewer115112153spewe_r
spewers124210663spewers
spieled104811883spiele_d
spieler93111233spiele_r
spielers10319653spielers
spile75230083spile__
spiled94621993spile_d
spiles84227913spile_s
spirea84015633spirea_
spireas94412513spireas
splat76129343sp_l_at
splay105816043sp_l_ay
spleens937103spleens
spleeny1234563spleeny
splent84720193sp_lent
spoken124610003spoke_n
sporran936743sporran
spread9312533sp_read
stela54019043stel_a_
stelae63716483stel_ae
stelai63912563stel_ai
stelar64013863stel_ar
stele55026843stele__
stelene7310253stelene
steles63725663stele_s
stella63612973stella_
stellar72610433stellar
stellas72813043stellas
stewpan1234193stewpan
stolen64315063stole_n
subdean1037403subdean
suldan72611043s_uldan
sullen62914293sulle_n
sultan63012593s_ultan
superclean1445403superclean
superfan1347453superfan
superman12310233superman
sweven1235983sweve_n
sylvan12257363s_ylvan
teleman959573_teleman
teleran7510183_teleran
unclean946973unclean
upleap10106843up_leap

Search took 7 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.406440125.6
2DLD Change Limit1340271725.86022871.5
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.32928233.7
 
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.