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

208 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
proas7502880(None) 
praos74923561praos
proa66229961proa_
prods85523551prods
profs105120891profs
progs86624151progs
proms95426411proms
props95726881props
pros65742781pro_s
pross76529401pross
prows106327011prows
psoas75012981psoas
anoas57226492anoas
aprons8316992aprons
areas55935782areas
arias55438032arias
aromas81018622aromas
arras55626142arras
boas66150832_boas
boras75938302boras
bras65746452br_as
broad84817692broad
broads94515152broads
broos75126412broos
bros65635662bro_s
brows105425982brows
croak115216632croak
croaks125812982croaks
crocs95722432crocs
crops96125242crops
cross75124502cross
crows105727312crows
drops85719502drops
dross65418092dross
eras45441502er_as
eros45238452ero_s
froes86126692froes
frogs96220772frogs
frons86124042frons
frows116623102frows
goas55239942_goas
groan65618422groan
groans74815062groans
groat65531972groat
groats74816652groats
grogs76319412grogs
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
horas86333102horas
irons55324132irons
koas85635102_koas
koras95927122koras
moas65545342_moas
moras76438782moras
orcas75918622orcas
pacas96029402pacas
papas94927492papas
paras76143052paras
parkas125018032parkas
parols84722612parols
parous84024162parous
pas58775742p__as
peas65755062p_eas
peons75327182peons
phons105221142phons
phots105418502phots
pias66542562p_ias
picas94626522picas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pions75826392pions
pious74621272pious
pitas77427672pitas
pleas75627032pleas
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
pods76540162p_ods
pois66539042p_ois
pols66044562p_ols
poms87037742p_oms
pons65850602p_ons
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112p_oos
pops86340952p_ops
pores75849032pores
porks115124142porks
porns75527342porns
porous84419482porous
ports75934592ports
pots66452362p_ots
pows95537662p_ows
praam94815612praam
praams10459642praams
pram85733492pr_am
prams96125512prams
prao66229022pr_ao
prase76128752pr_ase
prat65952042pr_at
prats76333392prats
prau66529472pr_au
praus74621752praus
pray96331532pr_ay
prays105022432prays
prees75937172prees
preops104911942preops
preps96220692preps
presa74319042presa
press75425952press
preys105717782preys
pries74339532pries
prigs85219702prigs
primas104418102primas
prims95425932prims
prions84317782prions
priors83914482priors
priss74623892priss
pro55837262pro__
probe94320812probe
probes104119452probes
prod76129502pro_d
proem94818272proem
proems104711162proems
prof96134662pro_f
prog75729002pro_g
prolan8414692prolan
prolans9314272prolans
prole74527792prole
proles84627202proles
prom87631702pro_m
promo95620002promo
promos105116422promos
prone75332622prone
prong85218112prong
prongs94314482prongs
proof105221532proof
proofs114511682proofs
prop85932812pro_p
prose75835122prose
proses84733472proses
proso77222412proso
prosos85718552prosos
prost75434102prost
prosy106319252prosy
proteas92015122proteas
proud84615482proud
prove104823192prove
proves114322252proves
prow97030382pro_w
prowar114110942prowar
prowl105615122prowl
prowls115511082prowls
proxy175011012proxy
psoae74411622psoae
psoai7469922psoai
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
purdas92612262purdas
pyas96225702p_yas
pyrolas1239862pyrolas
pyros105718292pyro_s
ras37575392_r_as
rias45540602_rias
road56332112_road
roads66523622_roads
roam67132412_roam
roams74919612_roams
roan47234202_roan
roans54926442_roans
roar46328572_roar
roars55622242_roars
roast56230142_roast
robs65837872_robs
rocs65533662_rocs
rods56442072_rods
roes45954142_roes
roms67038962_roms
rotas54827722_rotas
rots46454092_rots
rows75941752_rows
ryas77224612_ryas
soras55041012soras
stoas55126022stoas
toras55540372toras
troak95213572troak
troaks104410602troaks
trogs67022602trogs
trois57226092trois
tronas63816902tronas
trots56629942trots
trows88826182trows
troys86418612troys
uproar8106932uproar
uproars986452uproars
ureas55826012ureas
vrows116115262vrows

Search took 7 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 Filter178691538000.610292936.1
2DLD Change Limit538002086.1408762.2
3Display Results2082080.1261650.8
 (SQL Overall)1786912086.87625987.6
 
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.