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

142 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
zincite183723(None) 
incite83618731_incite
zincate1838531zincate
zincites1946631zincites
finite9316822fin_ite
incise83515332_incise
incited103314622_incited
inciter93113772_inciter
incites93218482_incites
indite73520322_indite
invite93715032_invite
miscite11314382miscite
pinite8321242pin_ite
reincite1089702reincite
zincates1937742zincates
zincic1935902zinci_c
zincify2443912zincify
zincing192910282zincing
binate8419773bin_ate
binit76431583bin_it_
binits85716673bin_its
biocide1237323biocide
biotite9311033biotite
calcite11413783calcite
cite65640353___cite
coincide1346493coincide
concise11314473concise
crinite9513633crin_ite
dacite91115883_dacite
dinette8310013dinette
diorite8314913diorite
dunite7315013dun_ite
dunnite857333dunnite
endite73817593_endite
evincive1642853evincive
excite15310883_excite
finites10315923fin_ites
finito9310303fin_ito
finlike14279063finlike
flinkite1543623flinkite
gunite7414403gun_ite
hircine1239143hircine
ignite71410583_ignite
illite63414923_illite
incage93513623_incage
incase83615283_incase
incised102911583_incised
incises93414893_incises
inciters103210673_inciters
incline9314643_incline
income10712093_income
incuse83513573_incuse
indie63721473_indi_e
indited93515023_indited
inditer83514233_inditer
indites83618983_indites
ingate73018243_ingate
inmate82917363_inmate
innate63917313_innate
inosite7314063_inosite
inside7613453_inside
intime81014273_intime
intine61021983_intine
intitle7610583_intitle
invited113612463_invited
invitee103713543_invitee
inviter104112313_inviter
invites103915813_invites
iolite63221983_iolite
kainite1149543kain_ite
kunzite2053503kunzite
lenite6719983len_ite
leucite937753leucite
licit74327683li_cit_
lignite81310303lignite
lineate7815153lineate
lucite8313343_lucite
mannite9312903mannite
minacity1547373minacity
mince95325233minc__e
mincier113512473mincier
mincing123314333mincing
minute83414293min_ute
miscited13310423miscited
miscites12313783miscites
niobite937953niobite
nite45943593__n_ite
nitrite72314463nitrite
penlite9313243penlite
picrite111911313picrite
pinites9319533pin_ites
pinkie124414273pinki_e
pinnate93613743pinnate
piscine11610973piscine
principe1445683principe
recite83625113_recite
reincited1246853reincited
reincites1148493reincites
reinvite1177753reinvite
sienite7312713sienite
since75024173sinc__e
sincere9310553sincere
sinicize1947333sinicize
sinuate7412163sinuate
tillite7313563tillite
tinct76126233tinc_t_
tincted1037273tinc_ted
tincts84510803tinc_ts
tinlike11248803tinlike
uintaite8127353uintaite
unciae83215313_unciae
uncute82912133_uncute
unite54828383_un_ite
vincible1544753vincible
wince105220883winc__e
wincing133413903wincing
yince105214253yinc__e
zenith1839073zen_ith
zeolite1638903zeolite
zinc156819103zinc___
zinced18419413zinc_ed
zincified2444293zincified
zincifies2344953zincifies
zincked2334233zincked
zincking2435463zincking
zincky24404963zinc_ky
zincoid1946663zincoid
zincous1837053zincous
zincs165312933zinc__s
zincy195413513zinc__y
zine137036163zin___e
zingare1737143zingare
zingier17369493zingier
zinging183513943zinging
zinkenite2242743zinkenite
zinkify2643123zinkify
zinnia1536013zinni_a
zinnias1635863zinnias
zizit13313273zi_zit_
zizith1744823zi_zith
zoisite1635833zoisite
zonate154114923zon_ate

Search took 10 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 Limit1340271428.64315507.0
3Display Results1421420.0602366.7
 (SQL Overall)1786911429.10919617.0
 
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.