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

187 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
picrite11191131(None) 
picrate112014141picrate
picrites121811081picrites
diorite8314912diorite
eucrite939902eucrite
nitrite72314462nitrite
picante11310522picante
picrated132110112picrated
picrates122013212picrates
picric12309922picri_c
picritic1448262picritic
pinite8321242pi_nite
pirate82322882pi_rate
pyrite11913312p_yrite
accrete1137843accrete
apocrine1246933apocrine
ascribe1147743ascribe
attrite7311833attrite
azurite1638003azurite
barite84224813_barite
becrime1387053becrime
biotite9311033biotite
cerite84724873_cerite
cirrate92413493cirrate
cite65640343__c_ite
citrate92216803citrate
citrine92514023citrine
cowrite123612683cowrite
crate76537403__crate
crime94822693__crime
cripe95521143__cripe
crit65743713__crit_
crits75527573__crits
cuprite1159683cuprite
curite85222943_curite
dacite91115883dac_ite
dichroite1545363dichroite
dickie133913113dicki_e
dictate10311663dictate
diorites9313523diorites
discrete11410283discrete
disrate81418523disrate
eccrine1137283eccrine
epiclike1644143epiclike
epicritic1545143epicritic
epizoite1944143epizoite
eucrites1049483eucrites
excite15310883exc_ite
excrete1667163excrete
ferrite103312753ferrite
fictile1238023fictile
fictive1537023fictive
finite9316823fi_nite
hickie153812473hicki_e
hircine1239143hircine
hypocrite1955403hypocrite
ichnite1245983_ichnite
ignite71410583_ignite
illite63414923_illite
incite83618733_incite
indite73520323_indite
invite93715033_invite
iolite63221983_iolite
irate55627983_i_rate
librate93214233librate
licente91210893licente
licit74327683lic_it_
licorice1246133licorice
lignite81310303lignite
lucite8313343luc_ite
micrify1744693micrify
microbe1338663microbe
migrate101314173migrate
miscite11314383miscite
misrate91319143misrate
miswrite1348923miswrite
nicoise937923nicoise
nictate9310223nictate
niobite937953niobite
nitrate72017013nitrate
nitride82811243nitride
nitrile73011373nitrile
nitrites82313453nitrites
norite63221133_norite
parity114719873p_arity
partite9317133partite
patriate10311933patriate
pearlite1039443pearlite
pectate112214693pectate
pectize20259913pectize
peerie83617893peeri_e
pelite84323003p_elite
penlite9313243penlite
periti8319953p_eriti
perlite9317313perlite
petite84320653p_etite
phorate12413363phorate
piccata1345703piccata
pice84641093pic___e
pickaxe2244623pickaxe
picket144924313picket_
picketed17167383picketed
picketer16187433picketer
pickets154314183pickets
pickier153912973pickier
picking163418333picking
pickle144215653pic_kle
picnic123410263picni_c
picnics13297343picnics
picoline12310853picoline
picot95031013pic_ot_
picoted1239213pic_oted
picotee11311473picotee
picots104616443pic_ots
picquet2047743picquet
picture1158613picture
picturize2244463picturize
pierce104010393pier_ce
piggie103210773piggi_e
piglike14157313piglike
pileate93815923pileate
pinites9319533pi_nites
pinkie124414273pinki_e
pinnate93613743pinnate
piosity1268643piosity
piperine122011833piperine
pipette1137943pipette
pipit95224873pi_pit_
pipits104713063pi_pits
pirated102515613pi_rated
pirates93020333pi_rates
piscine11610973piscine
pismire1135353pismire
pisolite10310373pisolite
piste75824603pi__ste
pixie145415523pi_xi_e
plicate11314513plic_ate
podite93315353p_odite
polite83625073p_olite
porcine11312843porcine
prate75135983p__rate
price93725413p__rice
pride84724733p__ride
prime96525603p__rime
priorate10411733priorate
priority1347443priority
prise74632613p__rise
prize164718943p__rize
prorate9418733prorate
puerile9310093puerile
pumicite1446813pumic_ite
purine85321893p_urine
purity114114913p_urity
pyrites12812203p_yrites
recite83625113rec_ite
recrate92621663recrate
rewrite10311143rewrite
rite45849453___rite
scribe104613533_scribe
scrive115414943_scrive
secrete9311073secrete
sickie123715743sicki_e
siderite9411363siderite
sienite7312713sienite
spicate113214193spic_ate
spirit83519923spi_rit_
spirited1148973spi_rited
spirits94112623spi_rits
sprite84421773_sprite
tacrine9311293tacrine
tectite9310583tectite
thorite10313443thorite
tillite7313563tillite
titrate72215573titrate
trichite1349333trichite
trite54730033__trite
uncrate9415953uncrate
verite94323443_verite
vibrate122811523vibrate
vicarate1378603vicarate
vicariate1476353vicariate
vicomte1445723vicomte
virile9313433vi_rile
vitrine102511363vitrine
write85522833__write
yperite1249893yperite
zincite1837233zincite

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271876.14021828.5
3Display Results1871870.0632968.3
 (SQL Overall)1786911876.35928100.5
 
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.