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 “zoisite” 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
zoisite163583(None) 
zoisites1744971zoisites
coesite9713622coesite
amosite9313163amosite
bhistie1236773bhistie
biotite9311033biotite
boite74426323bo__ite
bornite9311183bornite
coesites101313093coesites
cordite10315263cordite
cosie74728263co_si_e
cosine83823513co_sine
cowrite123612683cowrite
crinite9513633crinite
cuisine9310423cuisine
diorite8314913diorite
donsie7613643donsi_e
eosine64519413eo_sine
felsite1039083felsite
finite9316823_finite
foist85730973fois_t_
foisted113210603fois_ted
foists95413983fois_ts
fomite113314073fo_mite
fossate10388603fossate
gobshite1443273gobshite
gothite1146403gothite
hessite1038993hessite
hoise85224773hois__e
hoising113414413hoising
hoist86433213hois_t_
hoisted113411293hois_ted
hoister103714203hois_ter
hoists95516023hois_ts
homesite1359263homesite
hoplite12311073hoplite
horste94817413hors_te
inosite7314063inosite
iolite63221983io_lite
joist125125653jois_t_
joisted15379173jois_ted
joists134711033jois_ts
kainite1149543kainite
lewisite1154543lewisite
misate81222693_misate
miscite11314383_miscite
modiste1039283modis_te
moist76033583mois_t_
moisten93110143mois_ten
moister94015373mois_ter
moste75925083mo_s_te
niobite937953niobite
noise55723733nois__e
noisette846313noisette
noisier759453noisier
noisily1038403noisily
noising83615173noising
noisome947973noisome
norite63221133no_rite
onside7511803_onside
oolite63319603_oolite
ophite11410563_ophite
pinite8321243_pinite
piosity1268643piosity
piste75824603_pis_te
podite93315353po_dite
pointe84619313poi_nte
poise75127893pois__e
poising103617103poising
polite83625073po_lite
popsie103013053popsi_e
posit75833333po_sit_
posited10511493po_sited
posits85718713po_sits
postie84123963po_stie
potsie83916033potsi_e
resite64128453_resite
roister73516203rois_ter
site47052413___site
somite84519373so_mite
sonsie6614863sonsi_e
sopite84917713so_pite
subsite9412873subsite
topside1037733topside
triste63818643tris_te
troilite849543troilite
unisize1647343unisize
visit8320963_visit_
visited1168773_visited
visiter1038863_visiter
visits9311423_visits
visive1257873_visive
website1235323website
zeolite1638903zeolite
zincite1837233zincite
zizit13313273z_izit_
zizith1744823z_izith
zombie1937323zombi_e
zonate154114923zo_nate
zoster153715853zo_s_ter
zowie174313843zo_wi_e
zoysia1844163zoysi_a
zoysias1943843zoysias

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.296603685.8
2DLD Change Limit1340271037.18618651.1
3Display Results1031030.0333121.2
 (SQL Overall)1786911037.51523777.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.