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

136 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
zincites194663(None) 
incites93218481_incites
zincates1937741zincates
zincite1837231zincite_
finites10315922fin_ites
incises93414892_incises
incite83618732_incite_
incited103314622_incited
inciter93113772_inciter
inciters103210672_inciters
indites83618982_indites
invites103915812_invites
miscites12313782miscites
pinites9319532pin_ites
reincites1148492reincites
zincate1838532zincate_
zincifies2344952zincifies
ascites9312603_ascites
binits85716673bin_it_s
biocides1336933biocides
biotites10310083biotites
calcites12313003calcites
cinches144215773cinc_hes
cites74435593___cites
coincides1446433coincides
crinites10612753crin_ites
dacites101114593_dacites
dinettes9310193dinettes
dingies93618243dingi_es
dinkies123716033dinki_es
diorites9313523diorites
dunites8313593dun_ites
dunnites947173dunnites
endites83717063_endites
excites16310633_excites
fancies124018783fanci_es
finches153914193finc_hes
finises10312903fin_ises
finite9316823fin_ite_
flinkites1643483flinkites
gunites8313123gun_ites
hinnies103615103hinni_es
ignites81310583_ignites
illites72415013_illites
incages103013883_incages
incases93615973_incases
inches114419673_inc_hes
incise83515333_incise_
incised102911583_incised
inclines10313143_inclines
incomes11712373_incomes
incudes10319523_incudes
incuses93514853_incuses
indices103513443_indices
indies73822783_indi_es
indite73520323_indite_
indited93515023_indited
inditer83514233_inditer
inditers93311053_inditers
infixes17238133_infixes
ingates82716913_ingates
inmates92715783_inmates
inosites8312793_inosites
insides8512653_insides
intines7921113_intines
intitles8710003_intitles
invite93715033_invite_
invited113612463_invited
invitee103713543_invitee
invitees11377903_invitees
inviter104112313_inviter
inviters11359643_inviters
iolites73819483_iolites
kainites1238793kain_ites
kunzites2143243kunzites
lenites7818443len_ites
leucites1037333leucites
lignites9129613lignites
limites92915453li_mites
lindies8416583lindi_es
lucites9311863_lucites
mannites10312613mannites
minacities1447993minacities
minces104420803minc__es
mincier113512473minci_er
minciest122913103minci_est
minnies93617363minni_es
minutes93513443min_utes
miscite11314383miscite_
miscited13310423miscited
nancies93516843nanci_es
nineties8312913nineties
ninnies73713613ninni_es
niobites1037313niobites
nites55736343__n_ites
nitrites82313453nitrites
penlites10312273penlites
picrites121811083picrites
pinches144117933pinc_hes
pinite8321243pin_ite_
pinkies133818263pinki_es
pinnies93318443pinni_es
recites93524583_recites
reincite1089703reincite_
reincited1246853reincited
reinvites1287033reinvites
sienites8311913sienites
sinicizes2046793sinicizes
sinuates8310963sinuates
tillites8312833tillites
tincted1037273tinc_ted
tincts84510803tinc_t_s
tinnitus843783tinnitus
uintaites9136333uintaites
unites65024853_un_ites
winces114819113winc__es
winches154714373winc_hes
zanies153219673zan_i_es
zeniths1935153zen_iths
zeolites1738383zeolites
zilches21326303zilc_hes
zinced18419413zinc__ed
zincic1935903zinci__c
zincified2444293zincified
zincify2443913zinci_fy
zincing192910283zinci_ng
zincked2334233zinc_ked
zincous1837053zinc_ous
zincs165312933zinc___s
zines145232653zin___es
zingier17369493zingi_er
zingiest182810883zingi_est
zinkenites2342693zinkenites
zinkifies2543503zinkifies
zinnias1635863zinni_as
zoisites1744973zoisites

Search took 7 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621366.59322169.3
3Display Results1361360.0632158.7
 (SQL Overall)1786911366.81226231.8
 
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.