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

103 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
epicure113682(None) 
epicures1246511epicures
epicarp1376072epicarp
epicene1148592epicene
epicurean1352082epicurean
epimere1186982epimere
pedicure1345182pedicure
picture1158612_picture
spicule11269932spicule
apiculi1145113apiculi
cure66149123___cure
depicter1356853depicter
emigre937053emi_gre
empire1039323empi__re
encore8314773e_ncore
endure74014143e_ndure
ensure63416003e_nsure
enure53520223e__nure
epic86921303epic___
epical10413393epic_al
epicarps1444783epicarps
epicenes1249253epicenes
epiclike1644143epiclike
epics95014283epic__s
epicureans1451453epicureans
epicurism1543843epicurism
epicycle1743393epicycle
epiderm1236193epiderm
epidote1037393epidote
epidural1143723epidural
epigene1037893epigene
epigone1057843epigone
epilate9314283epilate
epimer10109153epimer_
epimeres12117653epimeres
epimers11109493epimers
episcope1445833episcope
episode1056303episode
episome1157813episome
epistle957893epistle
epitome1157743epitome
epitope1147053epitope
erasure736943erasure
euchre11137663e_uchre
evacuee12105073evacuee
evictee1248103evictee
excuse1537423e_xcuse
execute1636783execute
expire1538023expi__re
exposure1743673exposure
failure1035753failure
figure10258833_figure
fixure16256543_fixure
geniture946453geniture
guipure1043533guipure
inure54119053__inure
leisure736693leisure
ligure7279473_ligure
manicure1245803manicure
medicare1347483medicare
obscure1145333obscure
parure8312523_parure
pedicured1543593pedicured
pedicures1445263pedicures
perdure10379623perdure
perjure16327963perjure
picara10311903_picara
picaro10311323_picaro
pice84641093_pic__e
picker144422173_picker
pickle144215653_pickle
pictured1346573_pictured
pictures1249343_pictures
picul95015363_picu_l
piculs103511753_piculs
pilule8411123_pilule
pique16410173_piqu_e
precure11312553precure
procure1138573procure
pure65543333_p__ure
refigure1254693refigure
resecure1047183resecure
reticule1049303reticule
secure8513533_secure
seisure738193seisure
seizure1634683seizure
semicured1444263semicured
soilure736233soilure
spectre11297773spectre
spicae104313703spic_ae
spicate113214193spicate
spice95528813spic__e
spicer104719313spicer_
spicers113815553spicers
spicery14499013spicery
spicier115112463spicier
spicula11259293spicula
spiculae12218603spiculae
spicules12219803spicules
spinule9299993spinule
spire75828693spi__re
upcurl1034963up_curl
upcurve1463273up_curve

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 Limit1340271037.37318178.1
3Display Results1031030.0333121.2
 (SQL Overall)1786911037.81222873.9
 
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.