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

165 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
trews8611889(None) 
brews105617071brews
crews105917491crews
strews96817091strews
tews76431641t_ews
thews117416191thews
trees55835761trees
treks96016851treks
tres46542901tre_s
tress55423161tress
trets55928021trets
treys85018211treys
trows88826181trows
areas55935772areas
ares45871022are_s
braws106425192braws
brees75632552brees
brens75823362brens
brew95023562brew_
brewis11469982brewis
brows105425982brows
chews135418512chews
clews105516332clews
craws105723122craws
creds85418772creds
cress75022832cress
crew96122672crew_
crows105727312crows
dews86230602_dews
draws95119372draws
drees65628522drees
dregs76114862dregs
dreks105714742dreks
dress65319832dress
drew86221672drew_
flews115316442flews
frees86131392frees
frets85523402frets
frows116623102frows
grees65132472grees
grew85620262grew_
greys96614852greys
grows95523922grows
hews105631572_hews
ires45639282ire_s
jews145822082_jews
krewe1238192krewe
krewes1337922krewes
mews96629332_mews
news76127372_news
ores46056682ore_s
pews95731532_pews
plews105415352plews
prees75937172prees
preps96220692preps
press75425952press
preys105717782preys
prows106327012prows
raws75238212_raws
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_re_s
rets45352562_rets
revs75027052_revs
rows75941752_rows
screws115513882screws
sews75836022_sews
shews115924712shews
shrews129313912shrews
skews125413802skews
slews86220352slews
smews104612292smews
spews105015922spews
stews85519142stews
straws98718672straws
streps86218062streps
stress66616672stress
strew89220652strew_
strewn96710002strewn
strows96718272strows
taels56822072taels
tares57456562tare_s
taws75641592t_aws
teas45851492t_eas
teds54932572t_eds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582t_ees
tegs56031492t_egs
tels46841692t_els
tens45647412t_ens
terms75523472terms
terns55226872terns
tets45847452t_ets
tew66640152t_ew_
thaws116515462thaws
thens85921832thens
thew108226232thew_
thewy146311852thewy
thraws129211102thraws
threes97117322threes
threw1117315712threw_
throws129715232throws
tiers55526522tiers
ties45248312tie_s
tires55437492tire_s
toeas55726422toeas
toes46956442toe_s
tores55352672tore_s
tows78545552t_ows
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trawl84915872trawl
trawls94412392trawls
trays85623432trays
tread64821702tread
treads74817912treads
treat56240352treat
treats64821692treats
tree47745812tre_e
treed65626732treed
treen55622752treen
treens65317872treens
tref77030992tre_f
trek86222312tre_k
trend64817452trend
trends75513542trends
tressy9448552tressy
tret46653532tre_t
trey77228792tre_y
triens65417542triens
triers64321522triers
tries55742812tries
trigs65423062trigs
trims75021472trims
trios55528092trios
trips74923362trips
trogs67022602trogs
trois57226092trois
trots56629942trots
trow78031422trow_
troys86418612troys
trues54925322trues
trugs65516802trugs
truss54916922truss
tyees86019452tyees
tyers86220052tyers
tyes76433372tye_s
tyres84725232tyre_s
ureas55826012ureas
views11489642views
vrows116115262vrows
whews145114492whews
wrens85016242wrens
yews105323962_yews

Search took 2 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.0762351197.4
2DLD Change Limit538001651.39338621.7
3Display Results1651650.0463587.0
 (SQL Overall)1786911651.515117947.9
 
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.