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

108 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
prexes15491594(None) 
plexes155313531plexes
praxes156215181praxes
prees75937171pre_es
prexies163415001prexies
prezes173614691prezes
pyrexes19305831pyrexes
rexes124526951_rexes
apexes1539132apexes
arenes64928392arenes
aretes64425352aretes
bredes94818472bredes
brees75632552bre_es
breves115516422breves
bruxes154811022bruxes
cremes104517992cremes
crepes105419342crepes
cruxes154911562cruxes
dexes135224512_dexes
drees65628522dre_es
exes116530812__exes
flexes164512952flexes
frees86131392fre_es
freres94716172freres
grebes93813612grebes
grees65132472gre_es
hexes155123042_hexes
ibexes15436162ibexes
ilexes134510252ilexes
kexes166216812_kexes
krewes1337922krewes
lexes127225262_lexes
lurexes1436072lurexes
mirexes1636992mirexes
murexes1636972murexes
oryxes1674522oryxes
pareses94718882pareses
paxes144928422p_axes
pedes85327282p_edes
pees65257372p_e_es
peeves113814872peeves
pekes114623562p_ekes
peles75738082p_eles
penes75839222p_enes
peres76246642p_eres
perses85428062perses
pieces104217272pieces
pixes144323172p_ixes
plebes104313622plebes
plexus15377282plexus
poxes145325722p_oxes
prases84429022prases
prates84633162prates
praxis154012252praxis
precess11310862precess
precis103416702precis
pree67044732pre_e_
preed85128112pre_ed
preen75925052pre_en
preens85020112preens
prefer113813202prefer
prefers123713332prefers
prefixes20389232prefixes
premed114617752premed
premeds12389582premeds
premen105017802premen
premies113823062premies
premixes193110082premixes
preops104911942preops
preps96220692pre_ps
prese75228382prese_
preset84430982preset
presets94216422presets
press75425952pre_ss
presses93523152presses
prests84021262prests
pretest9517632pretest
prevues1239262prevues
prex135722972prex__
prexy174611572prex_y
preyed125313192preyed
preyer114413732preyer
preyers124412362preyers
preys105717782pre_ys
prices104524542prices
prides94324182prides
pries74339532pr_ies
primes104225262primes
prises84133172prises
prizes173819812prizes
probes104119452probes
proles84627202proles
proses84733472proses
proves114322252proves
proxies163014932proxies
prudes94215442prudes
prunes83419062prunes
purees84721682pure_es
pyrenes123511222pyrenes
pyxes175911402p_yxes
raxes124729392_raxes
redes65139122_redes
rees45364192_re_es
reges65628782_reges
sexes126126222_sexes
sprees85620642spre_es
trees55835762tre_es
vexes155719122_vexes

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 Filter178691825510.233766914.2
2DLD Change Limit825511087.51610983.4
3Display Results1081080.0761421.1
 (SQL Overall)1786911087.82522835.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.