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

168 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
ramee7463385(None) 
ragee65432661ragee
rakee96031171rakee
ramees84620891ramees
ramen75625191ramen
ramet75743141ramet
ramie75027821ramie
ranee55438101ranee
razee145827801razee
agee56241492_agee
ajee115928232_ajee
akee85936812_akee
alee46652322_alee
ameer75618982_ameer
amen66733152_amen
amie66339852_amie
arame75026622aram_e
arames84622572arames
armed86324432armed
armer76924442armer
armet76739452armet
awee76336642_awee
came87648752cam_e
camel96822802camel
cameo95924992cameo
cames97047312cames
crambe1239072crambe
dame77140312dam_e
dames85435852dames
dragee84415602dragee
drawee104413822drawee
fame95639392fam_e
famed115928342famed
fames105735922fames
frame105821802fram_e
framed125116522framed
framer114817442framer
frames115119862frames
gambe106219212gambe
game76644322gam_e
gamed95126392gamed
gamer84928942gamer
games86238552games
gamete9313592gamete
gamey115320552gamey
gramme114210332gramme
hame97043132ham_e
hames106138702hames
jambe165314752jambe
kame105728232kam_e
kames115024692kames
lame66849292lam_e
lamed85235292lamed
lamer75233702lamer
lames75445542lames
laree56036292laree
mamey125418832mamey
mamie95826002mamie
mammee94417852mammee
name65637412nam_e
named85223062named
namer75622102namer
names74833362names
payee105524722payee
race66746262ra_ce
raced87635312raced
raceme1039732raceme
racer75233022racer
races74943242races
rage55742352ra_ge
raged74829452raged
ragees74618662ragees
rages64539442rages
raggee84217602raggee
ragmen93712182ragmen
raise54828052raise
rajes125022782rajes
rake84841572ra_ke
raked105831422raked
rakees104516972rakees
raker94529792raker
rakes94440352rakes
rale45050562ra_le
rales54947492rales
ram56867272ram__
ramal74622242ramal
ramate83921682ramate
ramble104519972ramble
ramets83517392ramets
rami66034092ram_i
ramies84630462ramies
ramjet15311542ramjet
rammed113117302rammed
rammer103519652rammer
rammy124312492rammy
ramose8314402ramose
ramp85934002ram_p
ramped114617902ramped
ramps96224632ramps
rams65950772ram_s
ramus76418282ramus
rance75028512rance
ranees64623962ranees
range64728412range
rape65041632ra_pe
raped85334622raped
raper74932752raper
rapes75740722rapes
raphe104916422raphe
rappee103618672rappee
rare45348432ra_re
rared65738322rared
rarer54731702rarer
rares55247442rares
rase46149982ra_se
rased65033932rased
raser55633412raser
rases55447212rases
rate45458762ra_te
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
rathe85821922rathe
rave75542092ra_ve
raved94931432raved
ravel84621512ravel
raven84723442raven
raver85631492raver
raves85441972raves
rawer84623732rawer
raxed135622662raxed
raxes124729392raxes
rayed95127502rayed
raze135235432ra_ze
razed155027982razed
razeed163710012razeed
razees154314762razees
razer144824272razer
razes145032702razes
reamed94326122reamed
reamer84325212reamer
ree37974072r__ee
remeet86325472remeet
remet74843722remet
remex146315792remex
resee54336332resee
rheme106214052rheme
rime65138882rim_e
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
roamed95215092roamed
roamer84715162roamer
romeo73719702romeo
rumen74419502rumen
rupee7321282rupee
same65245642sam_e
samek114915272samek
saree55044662saree
tame66343662tam_e
tamed85528512tamed
tamer75230102tamer
tames75242012tames
tramel84113712tramel
wame95035482wam_e
wames106432802wames
yamen104115182yamen

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.326548131.9
2DLD Change Limit538001681.50035866.7
3Display Results1681680.0463652.2
 (SQL Overall)1786911681.87295454.6
 
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.