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

193 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
picrites12181108(None) 
picrates122013211picrates
picrite111911311picrite_
diorites9313522diorites
eucrites1049482eucrites
nitrites82313452nitrites
picrate112014142picrate_
picrated132110112picrated
picritic1448262picritic
pinites9319532pi_nites
pirates93020332pi_rates
pyrites12812202p_yrites
accretes1238113accretes
apiaries10312733apiari_es
ascites9312603asc_ites
ascribes1246193ascribes
attrites8311563attrites
azurites1737283azurites
barites94322333_barites
becrimes1467073becrimes
biotites10310093biotites
cerites94823433_cerites
cites74435593__c_ites
citrates102315093citrates
citrines102513133citrines
cowrites133011593cowrites
crates85736063__crates
cries75438403__cri_es
crimes105521583__crimes
cripes105120873__cripes
crises84529433__crises
crits75527573__crit_s
cuprites1259023cuprites
curites93919863_curites
dacites101114593dac_ites
decries103319813decri_es
diaries83321953diari_es
dichroites1645143dichroites
dickies143416343dicki_es
dictates11311383dictates
diorite8314913diorite_
dirties83119383di_rties
disrates91118153disrates
epicritic1545143epicritic
epizoites2043693epizoites
eucrite939903eucrite_
excites16310633exc_ites
excretes1787573excretes
ferrites112312833ferrites
finites10315923fi_nites
frites94922483__frites
hickies163614743hicki_es
hypocrites2055193hypocrites
ichnites1345743_ichnites
ignites81310583_ignites
illites72415013_illites
incites93218483_incites
indites83618983_indites
invites103915813_invites
iolites73819483_iolites
irides74519123_i_rides
irises64221173_i_rises
iritis63113733_i_ritis
librates103412953librates
licorices1346363licorices
lignites9129613lignites
limites92915453li_mites
lucites9311863luc_ites
micrifies16118673micrifies
microbes1439403microbes
migrates111112853migrates
miscites12313783miscites
misrates101318243misrates
miswrites1447983miswrites
niceties10310863niceties
nictates1039593nictates
niobites1037313niobites
nitrates82516223nitrates
nitrides92910703nitrides
nitriles8269923nitriles
nitrite72314463nitrite_
norites74018803_norites
paries84742513p_ari_es
parietes10714543p_arietes
parises94827183p_arises
parities10522973p_arities
parries93925843parri_es
parties93230863p_arties
patriates11311363patriates
pearlites1138233pearlites
pectates122213953pectates
pectines121914683pectines
pectizes21229793pectizes
peeries93623023peeri_es
pelites93821993p_elites
penlites10312273penlites
peritus9311803p_eritus
perlites10316363perlites
perries93226603perri_es
petites93820203p_etites
phorates13413043phorates
picante11310523picante_
pickaxes2344913pickaxes
picketed17167383picketed
picketer16187433picketer
picketers17196483picketers
pickets154314183picket_s
pickier153912973picki_er
pickiest162712593picki_est
pickiness1737623pickiness
pickings17359383pickings
pickles153215443pic_kles
picnics13297343picni_cs
picolines1339623picolines
picoted1239213pic_oted
picotee11311473pic_otee
picotees1247113picotees
picots104616443pic_ot_s
picquets2143733picquets
picric12309923picri__c
pictures1249343pictures
picturizes2344563picturizes
pierces113411193pier_ces
pieties9419223pieti_es
piggies113813483piggi_es
pigmies122610993pigmi_es
pigsties1139783pigsties
pineries102419083pineri_es
pinite8321243pi_nite_
pinkies133818263pinki_es
pinnies93318443pinni_es
piosities11311723piosities
piperines131610693piperines
pipettes1237563pipettes
pipits104713063pi_pit_s
pirate82322883pi_rate_
pirated102515613pi_rated
piscaries13410073piscari_es
pismires1235883pismires
pisolites1149383pisolites
pistes85325633pi__stes
pities83828083pi_ti_es
pixies154915513pi_xi_es
podites103014733p_odites
prates84633163p__rates
prices104524543p__rices
prides94324183p__rides
pries74339533p__ri_es
primes104225263p__rimes
priorates11410763priorates
priories10312453priori_es
priorities1249163priorities
prises84133173p__rises
prizes173819813p__rizes
prorates10418073prorates
pruritus1043943pruritus
pumicites1545623pumic_ites
purines94420763p_urines
purities10316283p_urities
pyrite11913313p_yrite_
recites93524583rec_ites
recrates102420373recrates
rewrites11311063rewrites
rites54442553___rites
scribes113713203_scribes
scries85226823_scri_es
scrives124414273_scrives
secretes10410473secretes
sickies133717503sicki_es
siderites10410433siderites
sienites8311913sienites
sorites73825243_sorites
spiceries1349313spiceri_es
spirited1148973spi_rited
spirits94112623spi_rit_s
sprites94220333_sprites
tacrines10310563tacrines
tectites1039993tectites
thorites11312393thorites
tillites8312833tillites
titrates82314663titrates
trichites1448883trichites
uncrates10314563uncrates
verites103822263_verites
vibrates132210613vibrates
vicarates1487623vicarates
vicariates1565533vicariates
vichies15310623vichi_es
vicomtes1545593vicomtes
vitrines112610913vitrines
writes94420333__writes
yperites13310153yperites
zincites1946633zincites

Search took 9 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.406440125.6
2DLD Change Limit1461621937.90618487.5
3Display Results1931930.0802412.5
 (SQL Overall)1786911938.39221293.0
 
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.