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

227 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
esprits93839(None) 
esprit8312841esprit_
sprits85122531_sprits
espies83716802esp_ies
estrins7315852estrins
resplits1037722resplits
spaits85017472_spaits
spirits94112622_spirits
spirts85317132_spirts
spits74429552_sp_its
splits85416412_splits
sprats85819932_sprats
sprigs94814772_sprigs
sprints94113772_sprints
sprit76736402_sprit_
sprite84421772_sprite
sprites94220332_sprites
spritz174714422_spritz
afrits9311903_afrits
aspects1146743aspects
asperity1347223asperity
aspics104211563asp_ics
aspires9612043aspires
aspirins1037733aspirins
aspis74618143asp_i_s
astricts1049463astricts
attrits7310623attrits
bowsprits1642153bowsprits
brits76433083__brits
capris10415083capri_s
cesspits1243663cesspits
crits75527573__crits
culprits1245583culprits
cuprite1159683cuprite
cuprites1259023cuprites
demerits11310763demerits
descries11311923descries
deserts82513053deser_ts
despairs1144943despairs
despite10410123desp_ite
despites11410313desp_ites
despoils1145623despoils
despots10319683desp_ots
dispirits1246153dispirits
edits65819033e__dits
egrets72712243e_grets
elegits8149343elegits
elicits9311233elicits
emeries91620023emeries
emerita938713emerita
emeritas1046433emeritas
emeriti949433emeriti
emeritus1045173emeritus
emits75421473e__mits
emperies12314563emperies
empires1139853empires
empirics1444003empirics
empress1138163empress
emprise11310723emprise
emprises12311003emprises
emprize2038843emprize
emprizes2138133emprizes
empties11712243empties
emptins1179403emptins
endrins8312163endrins
entries71523163entries
epacts105010393e_pacts
epics95014283e_p_ics
escorts9418403escorts
escots84211743es_cots
escrows1235803escrows
eserine7415903eserine
eserines8413743eserines
esparto944233esparto
espartos1044333espartos
espial839543esp_ial
espials937093espials
espied9359783esp_ied
espresso1043193espresso
espying1336193espying
essoins737603essoins
estrays10529403estrays
estreats839423estreats
estrin6315923estri_n
estriol747553estriol
estriols856253estriols
estrous7712533estrous
estrums9208603estrums
estrus61912113estr_us
eucrite939903eucrite
eucrites1049483eucrites
everts94514893ever_ts
exerts133712293exer_ts
exits125515913e__xits
expats1537683exp_ats
expects1866883expects
experts1659063experts
expires1638683expires
expiries1747753expiries
exploits1745973exploits
exports1647983exports
exposits1747243exposits
express1637493express
exserts1467013exser_ts
eyries93816813e_yries
frits86129103__frits
grits65529583__grits
imprints1247303imprints
inspirits1144253inspirits
jesuits1436323jes_uits
merits8320873_merits
mesquits19496483mesquits
misprints13107223misprints
newsprints1552753newsprints
oestrins8312673oestrins
ospreys1233143ospreys
pipits104713063pip_its
pits66348753__p_its
prats76333393__prats
pries74339533__pries
prigs85219703__prigs
prims95425933__prims
prints84320103__prints
priss74623893__priss
reprints1039903reprints
rescripts1374573rescripts
resits64725563res__its
resorts74817193resor_ts
respects1247703respects
respires10311903respires
respite9513033resp_ite
respites10513243resp_ites
resplit9310373resplit_
respots92912763resp_ots
resprays1344713resprays
respring111614063respring
resprings12156253resprings
resprouts1174823resprouts
restricts1138823restricts
sarins63932623_sarins
saris54544953_sari_s
scries85226823_scries
scrims104615933_scrims
scrips105316033_scrips
scripts11509373_scripts
secrets9311773secrets
sennits73811283sennits
sepias83616103sep_ias
sepsis83011293sepsi_s
septets998953septets
septics112810433septics
septs75420603sep__ts
series64540973_series
serifs94017053_serifs
serins64029673_serins
serries73925353serries
shirts94918343_shirts
shits84731173_s_hits
shrifts1335963_shrifts
shris84221453_shri_s
sits45050213_s__its
skirts104111503_skirts
skits94721873_s_kits
slits56128853_s_lits
snits54124833_s_nits
sorites73825243_sorites
sorts54536663_sor_ts
spails84817823_spails
spait75631603_spait_
sparids103512123_sparids
spats75031383_sp_ats
speils84116223_speils
speirs85013233_speirs
speiss84311643_speiss
spelts84614643_spelts
spics94123243_sp_ics
spies76037623_sp_ies
spiks114117473_sp_iks
spins75327983_sp_ins
spires84628113_spires
spirit83519923_spirit_
spirt75032953_spirt_
spit65545083_sp_it_
spite75430663_sp_ite
spites84127333_sp_ites
spitz166017973_sp_itz
spivs105114243_sp_ivs
splats84817303_splats
splints94511743_splints
split75729013_split_
spoils84614533_spoils
sports84619183_sports
spots74424113_sp_ots
spouts85115113_spouts
sprags95715823_sprags
sprains93013593_sprains
sprat76635973_sprat_
sprays115913643_sprays
sprees85620643_sprees
sprier84119063_sprier
spriest92718653_spriest
sprig85617743_spri_g
sprights14167143_sprights
spring94526013_spring
springs104415923_springs
sprint84526793_sprint
spritzes1946943_spritzes
sprouts949983_sprouts
sprues84515763_sprues
sprugs94010173_sprugs
spurts84814973_spurts
sris45434153_s_ri_s
straits74916323_straits
strips85719653_strips
struts65616803_struts
suits55028053_s_uits
territs72714503territs
tsarist7712253tsarist
tsarists857303tsarists
tsoris63411193tsori_s
tsuris62710203tsuri_s
usuries7510633usuries
vespids1334613vesp_ids
vestries11314053vestries
weskits1434743wes_kits
worrits10258683worrits
writs86624383__writs

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.406440125.6
2DLD Change Limit1340272276.67320085.0
3Display Results2272270.1102063.6
 (SQL Overall)1786912277.18924856.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.