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

211 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
zincate183853(None) 
zincates1937741zincates
zincite1837231zincite
binate8419772bin_ate
incage93513622_incage
incase83615282_incase
incite83618732_incite
ingate73018242_ingate
inmate82917362_inmate
innate63917312_innate
lineate7815152lineate
pinnate93613742pinnate
sinuate7412162sinuate
zincites1946632zincites
zingare1737142zingare
zonate154114922zon_ate
adnate72913483adn_ate
aduncate1145573aduncate
agnate73314883agn_ate
airdate8311323airdate
animate91617213animate
ansate64517863_ansate
baccate131011263baccate
bistate9313823bistate
cate66254603___cate
cicale10314503ci_cale
ciliate9514603ciliate
cineaste1045743cineaste
cirrate92413493cirrate
citrate92216803citrate
coinmate1239063coinmate
concave1439373concave
connate9315753connate
cuneate9311723cuneate
dentate8315153dentate
dictate10311663dictate
dilate73220693di_late
dinette8310013dinette
discase102912863discase
disrate81418523disrate
donate73619503don_ate
educate10310213educate
enate54428153_en_ate
encage93713503_encage
encase83714363_encase
falcate12311623falcate
filiate10414233filiate
finale94116763fin_ale
finca104714503finca__
fincas113512073finca_s
finite9316823fin_ite
fissate103010033fissate
fixate1638733fi_xate
furcate12310453furcate
ideate7313683_ideate
inane52820343_in_ane
incaged114010443_incaged
incages103013883_incages
incant82418513_incant
incanted11259543_incanted
incants92012803_incants
incased103612393_incased
incases93615973_incases
inchoate1347673_inchoate
incise83515333_incise
incited103314623_incited
inciter93113773_inciter
incites93218483_incites
income10712093_income
increate10312203_increate
incubate1238663_incubate
incudate1138873_incudate
incuse83513573_incuse
indicate11313353_indicate
indite73520323_indite
infante101910883_infante
infare9313083_infare
inflate10312313_inflate
ingates82716913_ingates
ingrate8715123_ingrate
inhale9411513_inhale
inlace82513043_inlace
inmates92715783_inmates
innage73011573_innage
insane6314893_insane
inscape1138023_inscape
instate71616483_instate
intake10510863_intake
invade10157853_invade
invite93715033_invite
invocate1347833_invocate
iodate7313503_iodate
irate55627983_i_rate
kinase104210653kin_ase
lanate6421263lan_ate
librate93214233librate
ligate72519253li_gate
limbate1139213limbate
linage7713403lin_age
lindane839033lindane
lineage878983lineage
lineated9711063lineated
linkage1295963linkage
liquate1638423liquate
locate83919843_locate
lunate6316043lun_ate
mandate10315573mandate
migrate101314173migrate
minae75627723min_a_e
mince95325233minc__e
mintage101110123mintage
minute83414293min_ute
misate81222693mi_sate
miscite11314383miscite
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrate72017013nitrate
ornate6315143orn_ate
ozonate1646863ozon_ate
pancake1536673pancake
pennate93314033pennate
picante11310523pi_cante
piccata1345703piccata
picrate112014143picrate
pileate93815923pileate
pinata83817223pin_ata
pinite8321243pin_ite
pinnace113510313pinnace
pinnae84414643pinna_e
pinnated11338553pinnated
pinwale1257843pinwale
pirate82322883pi_rate
placate11312433placate
plicate11314513plicate
punctate1246473punctate
quinate16511573quin_ate
reincite1089703reincite
ruinate7312833ruin_ate
saccate111311763saccate
senate63725173sen_ate
sensate7311893sensate
sigmate10710143sigmate
silicate10312623silicate
since75024173sinc__e
sincere9310553sincere
sinkage1287263sinkage
sinuated938413sinuated
sinuates8310963sinuates
situate7410783situate
sonicate10310933sonicate
spicate113214193spicate
spinate93114813spin_ate
sulcate9314423sulcate
tannate71813523tannate
thecate123210023thecate
tincal83913363tinca_l
tincals93610643tincals
tinct76126233tinc_t_
tincted1037273tinc_ted
tincts84510803tinc_ts
tinplate1047743tinplate
tinware1038603tinware
tipcat10312653tipcat_
tipcats1137103tipcats
titrate72215573titrate
toccate1138773toccate
truncate1046283truncate
tunicate103310043tunicate
uintaite8127353uintaite
uncage93014873_uncage
uncake122813523_uncake
uncase83817433_uncase
uncrate9415953_uncrate
uncute82912133_uncute
urinate7315363urin_ate
vacate11314553_vacate
vibrate122811523vibrate
vinca105315163vinca__
vincas113912453vinca_s
vindicate1546353vindicate
vintage11128143vintage
violate10311553violate
virgate1138733virgate
vitiate103412953vitiate
vittate10409733vittate
wince105220883winc__e
windage1237933windage
yince105214253yinc__e
zinc156819093zinc___
zinced18419413zinc_ed
zincic1935903zinc_ic
zincify2443913zincify
zincing192910283zincing
zincked2334233zincked
zincky24404963zinc_ky
zincoid1946663zincoid
zincous1837053zincous
zincs165312933zinc__s
zincy195413513zinc__y
zine137036153zin___e
zingani1744813zingani
zingano1744203zingano
zingara1745513zingara
zingari1745483zingari
zingaro1745123zingaro
zonae145116443zon_a_e
zonated173310533zon_ated

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 Limit1340272116.94019312.2
3Display Results2112110.0762776.3
 (SQL Overall)1786912117.42224075.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.