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

215 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
espials93709(None) 
espial839541espial_
despisals1243502despisals
espies83716802espi_es
sepals85217372sep_als
sepias83616102sepia_s
serials73919742serials
sials54227242_s_ials
spails84817822_spails
spiels85317952_spiels
spills84717462_spills
spinals93911862_spinals
spirals93212512_spirals
spitals93011592_spitals
aerials74017553aerials
apicals1159923_apicals
appals104812943_appals
appeals11378673appeals
asocials1075683asocials
asphalt1248083asphalt
asphalts1344183asphalts
aspics104211563aspi_cs
aspires9612043aspires
aspis74618143aspi__s
aspises9611643aspises
assails769093assails
astrals75515243astrals
bespeaks1643963bespeaks
bestial9311643bestial_
burials93612083burials
capias10318353capia_s
capitals12209443capitals
copals105018943cop_als
decrials1137133decrials
denials84114133denials
despairs1144943despairs
despisal1144673despisal_
despises1139433despises
despites11410313despites
despoils1145623despoils
dials64925343__dials
emails84412343emai_ls
empale102611263emp_ale
empales112411433emp_ales
empires1139853empires
entails7912823entails
ephahs1435503e_phahs
ephas10311543e_pha_s
epical10413393e_pical_
epics95014283e_pi_cs
epinaos936283e_pinaos
equals1538693e_quals
ervils948773ervi_ls
escars83913133es_cars
eschars1237173eschars
eskars10357593es_kars
especial1246293especial_
espied9359773espi_ed
espiegle1142603espiegle
espousals1152363espousals
esprits938393esprits
essays965653es_says
estival1036323estival_
estral64716513estral_
estrays10529403estrays
estriols856253estriols
ethicals1345533ethicals
evils84114263e_vi_ls
expats1537683exp_ats
expels1547173exp_els
expiable1946113expiable
expiate16910593expiate
expiates17810213expiates
expires1638683expires
exposals1744043exposals
facials123310743facials
fecials123510333fecials
festivals1543373festivals
fetials103711743fetials
finials103210153finials
gavials1136603gavials
hessians1145053hessians
hospitals1443903hospitals
keypals1634353keyp_als
labials9299873labials
lesbians1043603lesbians
medials103914733medials
menials94015683menials
mescals112911553mes_cals
mesial84818083mes_ial_
messiahs1343963messiahs
misdials1137493misdials
nopals84914023nop_als
nuptials1044303nuptials
opals75718353_op_als
pails75833063__pails
pals66951353__p_als
peals75235493__peals
phials1158873_phials
pial65636703__pial_
pians75126963__pians
pias66542553__pia_s
pibals103813083__pibals
pills74130973__pills
pipals104213643__pipals
pupils10389913pupi_ls
radials83614633radials
redials84416883redials
repeals94014523repeals
resails74616743resai_ls
reseals73917663res_eals
respeaks1434953respeaks
respells1056333respells
respires10311903respires
respites10513243respites
respools1036253respools
resprays1344713resprays
retrials8510823retrials
rials55026673__rials
rupiahs1253333rupiahs
sabals84618863_sabals
sails55738103_sai_ls
salals65120083_salals
sals46851673_s__als
seals54839693_s_eals
sendals81912263sendals
sepal77723003sep_al_
sepia75318673sepia__
septal84513383septal_
serails73318363serails
serial64625863serial_
servals103410743servals
sheals94420643_sheals
shiels95418923_shiels
shills94519613_shills
shoals94215793_shoals
sial45938833_s_ial_
sills55135993_s_ills
sisals63013573_sisals
skills104313923_skills
skirls10449823_skirls
skoals10438243_skoals
snails64816653_snails
socials999633socials
soils55327983_soi_ls
spaes76029973_sp_aes
spail74921553_spail_
spaits85017473_spaits
spale74929213_sp_ale
spales84728103_sp_ales
spall74919303_sp_all
spalls84217343_spalls
spams94922193_sp_ams
spans74528733_sp_ans
spars75431543_sp_ars
spas67036723_sp_a_s
spats75031383_sp_ats
spays105520513_sp_ays
speaks125114583_speaks
speans85417143_speans
spears84019473_spears
specials1238033_specials
speels85116393_speels
speils84116223_speils
spells84617683_spells
spicas104715823_spicas
spices104326033_spices
spicks144814993_spicks
spics94123243_spi_cs
spiel74623913_spiel_
spiers84421743_spiers
spies76037623_spi_es
spiffs14328473_spiffs
spikes124520713_spikes
spiks114117473_spi_ks
spile75230083_spi_le
spiles84227913_spiles
spill74821163_spi_ll
spilt75532223_spi_lt
spinal84915313_spinal_
spinels94512443_spinels
spines85132033_spines
spins75327983_spi_ns
spiral83715343_spiral_
spires84628113_spires
spirts85317133_spirts
spital83813873_spital_
spites84127333_spites
spits74429553_spi_ts
spivs105114243_spi_vs
splats84817303_splats
splays114910873_splays
spoils84614533_spoils
spools85115913_spools
sprags95715823_sprags
sprats85819933_sprats
sprawls12176373_sprawls
sprays115913643_sprays
steals64020063_steals
stills64118573_stills
swails94913123_swails
swills94213363_swills
swirls94010133_swirls
tepals85415043tep_als
tertials8510073tertials
thespians1442843thespians
trials64319883_trials
uncials92510523uncials
urials64415193_urials
usuals637783us_uals
vesperals1443933vesperals
vespiary1642743vespiary
vespids1334613vespi_ds
vestals104612333ves_tals
vials85822383__vials

Search took 8 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.420425454.8
2DLD Change Limit1340272156.64020184.8
3Display Results2152150.0633412.7
 (SQL Overall)1786912157.12325086.5
 
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.