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

175 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
prides9432418(None) 
brides94423511brides
grides84422361grides
irides74519121irides
prices104524541prices
pride84724741pride_
prided103618031prided
pries74339531pri_es
primes104225261primes
prises84133171prises
prizes173819811prizes
prudes94215441prudes
rides66140821_rides
abides94719892abides
aides65336612_aides
amides95722662amides
aphides134711202aphides
apsides103911302apsides
arider74717742arider
aridest8316142aridest
arises65233802arises
asides75118872asides
azides165113802azides
bides85536782_bides
borides10515152borides
bredes94818472bredes
bribes105918532bribes
bride86425542bride_
bridges113911332bridges
bridles104114472bridles
bries74942152bri_es
brines85028852brines
brises84927612brises
chides124620472chides
cries75438402cri_es
crimes105521582crimes
cripes105120872cripes
crises84529432crises
crudes96218622crudes
derides93420852derides
dries64733672dri_es
drives105117112drives
elides74420692elides
erodes74819882erodes
fridges12369482fridges
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
glides84518862glides
grades84926312grades
gride75223592gride_
grided95117042grided
grids75321402grid_s
grimes94619032grimes
gripes94619872gripes
guides84118282guides
hides95129432_hides
ides57734242__ides
imides94515342imides
irades74517392irades
irids66417782irid_s
irises64221172irises
krises105016082krises
nides65229142_nides
oreides8312022oreides
oroides8311972oroides
oxides14109692oxides
parades104121472parades
paries84742522pari_es
parises94827192parises
pedes85327292p_edes
peises84125042peises
phizes20389132phizes
pies66949612p_i_es
pikes115031032p_ikes
piles74742612p_iles
pines76048862p_ines
pipes96030142p_ipes
pixes144323172p_ixes
plies74526512pli_es
poises84226542poises
praises94121112praises
prases84429022prases
prates84633162prates
praxes156215182praxes
prees75937172pr_ees
presides11414912presides
prexes154915952prexes
prezes173614692prezes
price93725412price_
priced115018882priced
pricer103918292pricer
pricers113915062pricers
pricey134412632pricey
pricks144414262pricks
pried84426862pri_ed
prier75027762pri_er
priers84521192priers
priest84125422pri_est
prigs85219702pri_gs
prills84015612prills
primas104418102primas
prime96525602prime_
primed115118912primed
primer105118682primer
primers114215672primers
primos104514422primos
primps124711822primps
prims95425932pri_ms
primus103712172primus
princes113015152princes
prinks124315382prinks
prints84320102prints
prions84317782prions
priors83914482priors
prise74632612prise_
prised94322202prised
prisms104915502prisms
priss74623892pri_ss
prisses94816712prisses
privet113821342privet
privets122910052privets
privies122414262privies
prize164718942prize_
prized184415392prized
prizer174714882prizer
prizers183911842prizers
probes104119452probes
prods85523552prod_s
proles84627202proles
proses84733472proses
proves114322252proves
provides1439882provides
prude84615972prude_
prunes83419062prunes
purines94420772purines
pyrites12812202pyrites
pyxides2034422pyxides
redes65139132_redes
ribes75530172_ribes
rices75536152_rices
ride55945142_ride_
rider65231312_rider
riders74123902_riders
ridges85817012_ridges
rids56539562_rid_s
riles55343642_riles
rimes75634542_rimes
ripes75435772_ripes
rises55244042_rises
rites54442552_rites
rives85336002_rives
rodes614039082_rodes
sides65838372_sides
slides73922182slides
sprites94220332sprites
strides84520392strides
tides64830162_tides
trades75724502trades
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trines64132562trines
triodes84012502triodes
tripes85324872tripes
uprises92012732uprises
upsides10319632upsides
ureides8311102ureides
urines64724122urines
wides94832832_wides
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 Limit825511752.57632046.2
3Display Results1751750.0632777.8
 (SQL Overall)1786911752.98259923.2
 
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.