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

254 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
prases8442902(None) 
crases85532311crases
erases64425401erases
parses85534701parses
pases75346501p_ases
peases85229471peases
phases114618401phases
phrases12711461phrases
praises94121101praises
prase76128751prase_
prates84633161prates
praxes156215181praxes
prises84133171prises
proses84733471proses
rases55447211_rases
urases63723561urases
abases85720772abases
apyrases1337242apyrases
arames84622572arames
arises65233802arises
arrases71214542arrases
arses55733872ar_ses
baases85218012baases
bases75644352_bases
biases84618432biases
braces108427772braces
braes75735052bra_es
braises93818872braises
brakes124923122brakes
brashes124518462brashes
brass75428022bras_s
brasses93818352brasses
braves115524082braves
brazes175522192brazes
brises84927612brises
broses86524402broses
carses85233652carses
cases75048382_cases
ceases84427072ceases
chases115128232chases
crakes124921812crakes
cranes84330752cranes
crapes104727692crapes
crashes124618402crashes
crasis85020472crasis
crass76328042cras_s
crates85736052crates
craves115825392craves
crazes174720132crazes
creases94020962creases
crises84529432crises
cruses88127712cruses
drakes114715862drakes
drapes95419652drapes
druses75517252druses
eases56041612_eases
erase54925492erase_
erased74816752erased
eraser64216332eraser
erasers74413942erasers
eroses65327052eroses
erses55826802er_ses
eyases94513682eyases
feases95422922feases
fraises104215692fraises
frames115119862frames
frass85321122fras_s
frasses104314512frasses
frises94124272frises
gases65633992_gases
graces94523492graces
grades84926312grades
grapes95123122grapes
grasps9489252grasps
grass66125202gras_s
grasses84117342grasses
grates75429882grates
graves104624002graves
grazes164519642grazes
greases84816712greases
gyrases11368312gyrases
irades74517392irades
irises64221172irises
krises105016082krises
kvases13467102kvases
lases54944762_lases
leases65428112leases
lyases95211872lyases
marses84827112marses
myases113711552myases
oases55330982_oases
orates64328612orates
paces96741112p_aces
pages85235072p_ages
pales75753802p_ales
panes76148692p_anes
parades104121462parades
pares77164482p_ares
pareses94718872pareses
parges94529542parges
paries84742512paries
parises94827182parises
parles86334392parles
parse75236992parse_
parsec105914472parsec
parsecs11429912parsecs
parsed96323892parsed
parser84822372parser
parsers94118152parsers
pase65346862p_ase_
paseo77022512p_aseo
paseos88015812p_aseos
pashes115828392p_ashes
pass65239952p_as_s
passe75525692p_asse
passes86030472passes
pastes85233912p_astes
pasts75936502p_asts
pates76047892p_ates
pauses84621472pauses
paves104833922p_aves
paxes144928422p_axes
peaces106324082peaces
peages94321842peages
pease75231112pease_
peasen84815952peasen
peises84125042peises
perses85428062perses
peruses94018162peruses
phages125213512phages
phase104617212phase_
phased124011972phased
phasis114614922phasis
phrase11109902phrase_
phrased1387382phrased
physes14399782physes
pirates93020322pirates
pisses84525082pisses
places104323702places
plages94520152plages
planes85028082planes
plashes124417392plashes
plasms103711332plasms
plates85432242plates
pleases94515482pleases
pluses83618072pluses
poises84226542poises
poses74642762p_oses
posses85128802posses
praams10459642praams
prahus11458242prahus
praise84419412praise_
praised104214812praised
praiser93413942praiser
praisers103410832praisers
prams96125512pra_ms
prances113618772prances
prangs94816232prangs
pranks124814722pranks
praos74923562pra_os
prate75135982prate_
prated94924922prated
prater84825352prater
praters94921642praters
prats76333392pra_ts
praus74621752pra_us
prawns11509022prawns
praxis154012252praxis
praxises1739062praxises
prayed124815432prayed
prayer114815292prayer
prayers124212852prayers
prays105022432pra_ys
prees75937172pr_ees
prese75228382prese_
preset84430982preset
presets94216422presets
press75425952pres_s
presses93523152presses
prests84021262prests
prexes154915942prexes
prezes173614692prezes
prices104524542prices
prides94324182prides
pries74339532pr_ies
primes104225262primes
prise74632612prise_
prised94322202prised
prisms104915502prisms
priss74623892pris_s
prisses94816712prisses
prizes173819812prizes
probes104119452probes
proles84627202proles
prose75835122prose_
prosed94921092prosed
proser84223462proser
prosers94219642prosers
prosos85718552prosos
pross76529402pros_s
prosses94019512prosses
protases102115032protases
proves114322252proves
prudes94215442prudes
prunes83419062prunes
ptoses83514672ptoses
pulses83818662pulses
purses84826372purses
puses75532202p_uses
pusses84322842pusses
pyoses114314302pyoses
races74943242_races
rages64539442_rages
raises64826542_raises
rajes125022782_rajes
rakes94440352_rakes
rales54947492_rales
rapes75740722_rapes
rares55247442_rares
rase46149982_rase_
rased65033932_rased
raser55633412_raser
rasers64526782_rasers
rashes95330152_rashes
rasps74316662_rasps
rates55352012_rates
raves85441972_raves
raxes124729392_raxes
razes145032702_razes
rises55244042_rises
roses56445772_roses
ruses56136582_ruses
stases64225562stases
teases65426272teases
traces85329932traces
trades75724492trades
trapes85024462trapes
trashes104119252trashes
trass56226472tras_s
trasses74819322trasses
traves94222742traves
ukases10358062ukases
upases84112902upases
upraises10188472upraises
uprates93814862uprates
uprises92012732uprises
urares64519092urares
urase54624682urase_
urates65027762urates
ureases74416722ureases
uruses63616502uruses
vases84626262_vases
wrasse9398772wrasse
wrasses103812592wrasses

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.1231452772.4
2DLD Change Limit825512542.84629006.0
3Display Results2542540.0763342.1
 (SQL Overall)1786912543.04558683.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.