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

223 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
esprit831284(None) 
esprits938391esprits
sprit76736401_sprit
estrin6315922estrin
resplit9310372resplit
spait75631602_spait
spirit83519922_spirit
spirt75032952_spirt
spit65545082_sp_it
split75729012_split
sprat76635972_sprat
sprig85617742_sprig
sprint84526792_sprint
sprite84421772_sprite
sprits85122532_sprits
spritz174714412_spritz
afrit8323173_afrit
aspect10612823aspect
asperity1347223asperity
aspic95114733asp_ic
aspire8612123aspire
aspirin937823aspirin
aspis74618143asp_is
astrict9614783astrict
attrit6315743attrit
besprent1248033besprent
bestrid1039973bestrid
bowsprit1543653bowsprit
brit66350153__brit
capric12411793capric
capris10415073capris
cesspit1145463cesspit
crit65743713__crit
culprit1147863culprit
cupric1249113cupric
cuprite1159683cuprite
demerit10314993demerit
desert72725493deser_t
despair1045463despair
despite10410123desp_ite
despoil1046523despoil
despot93413293desp_ot
dispirit1149193dispirit
edit54934863e__dit
eerie55228533e_erie
egret63327313e_gret
elegit71212893elegit
elicit8417203elicit
emerita938713emerita
emeriti949433emeriti
emit65438413e__mit
empire1039313empire
empiric1345963empiric
emporia1148753emporia
emprise11310723emprise
emprize2038843emprize
endrin7312403endrin
engirt71112613engirt
epact94921533e_pact
epic86921303e_p_ic
erst47436433e__rst
escort84616483escort
escot75320083es_cot
escrow1135913escrow
eserine7415903eserine
esparto944233esparto
espial839543espial
espied9359773espied
espies83716803espies
espy969373esp__y
espying1336193espying
essoin638193essoin
estral64716513estral
estray95713333estray
estreat7314813estreat
estrins7315853estrins
estriol747553estriol
estrum81810513estrum
estrus61912113estrus
esurient849293esurient
eucrite939903eucrite
evert84929513ever_t
exert124624143exer_t
exit114428673e__xit
expat14313813exp_at
expect1758903expect
expert15515353expert
expire1538023expire
expiry1834653expiry
exploit1648623exploit
export15412183export
exposit1649683exposit
exsert13414363exser_t
eyrie88117833e_yrie
eyrir8359653e_yrir
forrit91916623forrit
frit77044473__frit
grit55247243__grit
imprint11312553imprint
inspirit1046283inspirit
jesuit1339583jes_uit
merit7339183_merit
mesquit18387953mesquit
misprint12912973misprint
miswrit1249413miswrit
newsprint1444363newsprint
oestrin7312233oestrin
osprey1134883osprey
pipit95224873pip_it
pit56471923__p_it
prat65952043__prat
presplit1247753presplit
prig75924873__prig
prim85132203__prim
print74837463__print
reprint9318983reprint
rescript1277423rescript
resit54241043res__it
resort65728613resor_t
respect11412033respect
respelt9312143respelt
respire9411543respire
respite9513033resp_ite
resplits1037723resplits
respot83117633resp_ot
respray1236503respray
respring111614063respring
resprout1078783resprout
restrict10313633restrict
sari45444043_sari_
sarin55239253_sarin
saris54544953_saris
scrim95419723_scrim
scrip96619193_scrip
script105717903_script
secret8325063secret
sennit63117923sennit
sepia75318673sep_ia
sepic94617053sep_ic
sepsis83011293sepsis
sept65844363sep__t
septet8921133septet
septic102713183septic
serif84132123_serif
serin55434443_serin
shirt84533893_shirt
shit76745933_s_hit
shri76021693_shri_
shrift12413543_shrift
shris84221443_shris
sit35877753_s__it
skirt95624663_skirt
skit85437523_s_kit
slit46250103_s_lit
smit65138403_s_mit
snit46342473_s_nit
sori46039833_sori_
sort46264813_sor_t
spail74921553_spail
spaits85017473_spaits
sparid94016933_sparid
spat66548523_sp_at
speil75618643_speil
speir75315363_speir
spelt75430193_spelt
spent75532833_spent
spic85227433_sp_ic
spik105419713_sp_ik
spilt75532223_spilt
spin66231303_sp_in
spire75828693_spire
spirits94112623_spirits
spirts85317133_spirts
spiry105017353_spiry
spite75430663_sp_ite
spits74429553_sp_its
spitz166017963_sp_itz
spiv95917793_sp_iv
splat76129343_splat
splint85223283_splint
splits85416413_splits
spoil75818643_spoil
spoilt85016593_spoilt
sport75935983_sport
spot65540683_sp_ot
spout75029633_spout
sprag86418693_sprag
sprain83614863_sprain
sprats85819933_sprats
spray106720063_spray
spree74830863_spree
sprent84522383_sprent
sprier84119063_sprier
spriest92718643_spriest
spright132010403_spright
sprigs94814773_sprigs
spring94526013_spring
sprints94113773_sprints
sprites94220333_sprites
sprout8419403_sprout
sprue74717633_sprue
sprug85313893_sprug
spry96819123_spr_y
spurt77227983_spurt
sri35634003_s_ri_
sris45434153_s_ris
strait64025893_strait
stria55723203_stria
strict84821043_strict
strip77524333_strip
stript85222193_stript
strut56030733_strut
suit45649873_s_uit
territ63421373territ
tsarist7712253tsarist
tsoris63411193tsoris
tsuris62710203tsuris
unsplit956563unsplit
uplit76020803_uplit
vespid1246083vesp_id
weskit1338343wes_kit
worrit92313313worrit
writ75537913__writ

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162236.95316211.1
3Display Results2232230.0802787.5
 (SQL Overall)1786912237.17324911.6
 
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.