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 “primes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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
primes10422526(None) 
crimes105521581crimes
grimes94619031grimes
prices104524541prices
prides94324181prides
pries74339531pri_es
primas104418101primas
prime96525601prime_
primed115118911primed
primer105118681primer
primers114215671primers
primos104514421primos
primps124711821primps
prims95425931prim_s
primus103712171primus
prises84133171prises
prizes173819811prizes
rimes75634541_rimes
animes84719592animes
arames84622572arames
arises65233802arises
armies85123692armies
berimes115216642berimes
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brims94721622brim_s
brines85028852brines
brises84927612brises
bromes104719762bromes
brumes106417072brumes
chimes134922572chimes
climes104720002climes
cremes104517992cremes
cries75438402cri_es
crime94822692crime_
crimps124613452crimps
cripes105120872cripes
crises84529432crises
dimes85833042_dimes
dries64733672dri_es
drives105117112drives
frames115119862frames
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
glimes94717522glimes
grides84422362grides
grime85021322grime_
grimed104714092grimed
gripes94619872gripes
grumes94415552grumes
irides74519122irides
irises64221172irises
krises105016082krises
limes75636502_limes
mimes95732022_mimes
optimes1148472optimes
oximes15107422oximes
paries84742512pari_es
parises94827182parises
peises84125042peises
phizes20389132phizes
pies66949602p_i_es
pikes115031032p_ikes
piles74742612p_iles
pimas94725102p_imas
pimps114616982p_imps
pines76048862p_ines
pipes96030142p_ipes
pixes144323172p_ixes
plies74526512pli_es
plumes104318132plumes
poises84226542poises
pomes94833932p_omes
praises94121102praises
prams96125512pram_s
prases84429022prases
prates84633162prates
praxes156215182praxes
prees75937172pr_ees
premed114617762premed
premeds12389592premeds
premen105017802premen
premies113823062premies
prexes154915952prexes
prezes173614692prezes
price93725412price_
priced115018882priced
pricer103918292pricer
pricers113915062pricers
pricey134412632pricey
pricks144414262pricks
pride84724732pride_
prided103618032prided
pried84426862pri_ed
prier75027762pri_er
priers84521192priers
priest84125422pri_est
prigs85219702pri_gs
prills84015612prills
prim85132202prim__
prima95019342prim_a
primages13159272primages
primal104014622primal
primates121515932primates
primely1457722primely
primero11368922primero
primeros12336882primeros
primi95017402prim_i
primines123013702primines
primly13439622primly
primmed14388852primmed
primmer134310162primmer
primmest14226692primmest
primness1276762primness
primo95017912prim_o
primp115615922prim_p
primped14479152primped
primuses1237082primuses
princes113015142princes
prinks124315382prinks
prints84320102prints
prions84317782prions
priors83914482priors
prise74632612prise_
prised94322202prised
prisms104915502prisms
priss74623892pri_ss
prisses94816712prisses
privet113821342privet
privets122910052privets
privies122414262privies
prize164718942prize_
prized184415392prized
prizer174714882prizer
prizers183911842prizers
probes104119452probes
proems104711162proems
proles84627202proles
promos105116422promos
proms95426412prom_s
proses84733472proses
proves114322252proves
prudes94215442prudes
prunes83419062prunes
purines94420762purines
pyrites12812202pyrites
ribes75530172_ribes
rices75536152_rices
rides66140812_rides
riles55343642_riles
rime65138882_rime_
rimed84826372_rimed
rimer75429242_rimer
rimers84522552_rimers
rims65936302_rim_s
ripes75435772_ripes
rises55244042_rises
rites54442552_rites
rives85336002_rives
slimes84722042slimes
sprites94220332sprites
stimes85920572stimes
times75630822_times
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trimer85717152trimer
trimers94615142trimers
trims75021472trim_s
trines64132562trines
tripes85324872tripes
uprises92012732uprises
uptimes1177552uptimes
urines64724122urines
wries85827742wri_es
writes94420332writes

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511812.75030018.5
3Display Results1811810.0603016.7
 (SQL Overall)1786911813.15356673.3
 
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.