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

161 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
arame7502663(None) 
arames84622571arames
frame105821801frame
abamp11310602abamp
abase76023482abase
abate76627842abate
abrade9313052abrade
acme86924322a_cme
adage7414052adage
aerate64830552aerate
aflame1138722aflame
agama85815582agama
agape85614842agape
agate66525152agate
agave95314032agave
agaze156113662agaze
agrafe1038092agrafe
alae45643752ala_e
alamo7418142alamo
alane56135612alane
alate55340332alate
alme65832162a_lme
amaze166016602amaze
anime75423202anime
apace94718382apace
arable81821002arable
arak86929582ara_k
araks94820882araks
aramid93315612aramid
arcade91013642arcade
arcane81216742arcane
are37874572ar__e
areae55229752areae
arene55329412arene
arete56031352arete
argle65421562argle
argue64818442argue
arise56436432arise
arm58449632ar_m_
armed86324442ar_med
armer76924452ar_mer
armet76739462ar_met
arms66137502ar_ms
army96624192ar_my
aroma71220152aroma
arose55832082arose
arse46539272ar_se
arum66129032arum_
arums75517832arums
asrama839192asrama
aurae54128112aura_e
aurate64426472aurate
awake125014782awake
aware86420022aware
blame95625492blame
brace95629272brace
brae65639112bra_e
brake116025342brake
brave104925502brave
braze165423452braze
brome94421972brome
brume95817982brume
came87648752_came
carafe115416162carafe
caramel11310252caramel
carate84734002carate
crake114823522crake
cram85635492cram_
crambe1239072crambe
cramp115120692cramp
crams96229152crams
crane75331602crane
crape96128442crape
crate76537402crate
crave105626312crave
craze165221462craze
creme94319322creme
crime94822692crime
dame77140312_dame
drake104918302drake
dram75832002dram_
drama85117432drama
drams86025832drams
drape85319632drape
drave95219272drave
erase54925492erase
fame95639392_fame
flame105124442flame
frae75330472fra_e
framed125116522framed
framer114817442framer
frames115119862frames
game76644322_game
garage8314512garage
grace85124542grace
grade75126092grade
gram77034582gram_
grama85620292grama
gramme114210332gramme
gramp106218322gramp
grams85327312grams
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
grime85021322grime
grume86218162grume
hame97043132_hame
irade65618152irade
irate55627982irate
kame105728252_kame
karate105320932karate
lame66849292_lame
macrame1338712macrame
madame1139852madame
name65637412_name
orate55133302orate
parade94720642parade
parae76335712para_e
paramo102614652paramo
pram85733492pram_
prams96125512prams
prase76128752prase
prate75135982prate
prime96525602prime
race66746262_race
rage55742352_rage
rake84841572_rake
rale45050562_rale
ram56867272_ram_
ramee74633852_ramee
ramen75625192_ramen
ramet75743142_ramet
rami66034092_rami
ramie75027822_ramie
ramp85934002_ramp
rams65950772_rams
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
rime65138892_rime
same65245642_same
sarape84817572sarape
shame105726702shame
tame66343662_tame
tarama8412742tarama
trace75829612trace
trade65026042trade
tram67034552tram_
tramel84113712tramel
tramp96319772tramp
trams75327672trams
trave85223032trave
urare56322552urare
urase54624692urase
urate55432162urate
wakame1535432wakame
wame95035482_wame

Search took 3 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.343520965.0
2DLD Change Limit538001611.90628226.7
3Display Results1611610.0463500.0
 (SQL Overall)1786911612.29577861.0
 
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.