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

116 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
ramees8462089(None) 
ragees74618661ragees
rakees104516971rakees
ramee74633851ramee_
ramets83517391ramets
ramies84630461ramies
ranees64623961ranees
razees154314761razees
akees96119242_akees
ameer75618982_ameer
ameers84015572_ameers
amens75624842_amens
amies76837692_amies
arames84622572aram_es
armers85520272armers
armets84918352armets
armies85123692armies
camels105217082camels
cameos105818002cameos
cames97047312cam_es
crambes1339962crambes
dames85435852dam_es
dragees9359482dragees
drawees11378362drawees
fames105735922fam_es
framers125113822framers
frames115119862fram_es
gambes116318312gambes
gamers94420832gamers
games86238552gam_es
gametes10312252gametes
grammes123611322grammes
hames106138702ham_es
jambes175914052jambes
kames115024692kam_es
lameds94812032lameds
lames75445542lam_es
larees65323112larees
mameyes14376982mameyes
mameys13449522mameys
mamies104626242mamies
mammees104411142mammees
namers84517332namers
names74833362nam_es
payees114812902payees
rabies85226022rabies
racemes1139092racemes
racers84725432racers
races74943242ra_ces
ragee65432662ragee_
rages64539442ra_ges
raggees93710912raggees
raises64826542raises
rajes125022782ra_jes
rakee96031172rakee_
rakers104123572rakers
rakes94440352ra_kes
rales54947492ra_les
rambles113118312rambles
ramen75625192ram_en
ramet75743142ram_et
ramie75027822ramie_
ramjet15311542ramjet
ramjets1635162ramjets
rammed113117302rammed
rammer103519652rammer
rammers113715042rammers
ramose8314402ramose
ramous8417112ramous
ramped114617902ramped
ramps96224632ram_ps
rams65950772ram__s
ramus76418282ram_us
rances84625442rances
ranee55438102ranee_
ranges73826922ranges
rapers84327182rapers
rapes75740722ra_pes
raphes115117452raphes
rappees113611452rappees
rares55247442ra_res
rasers64526782rasers
rases55447212ra_ses
rashes95330152rashes
ratels64518212ratels
raters63936582raters
rates55352012ra_tes
ravels94717072ravels
ravens93916882ravens
ravers94628182ravers
raves85441972ra_ves
raxes124729392ra_xes
razee145827802razee_
razeed163710012razeed
razers154919612razers
razes145032702ra_zes
razzes144910072razzes
reamers94221082reamers
rees45364192r__ees
remeet86325472remeet
remeets93712412remeets
resees63827482resees
rhemes115913182rhemes
rimers84522552rimers
rimes75634542rim_es
roamers93713462roamers
romeos84013172romeos
rumens83611812rumens
rupees8312572rupees
sameks12409322sameks
sarees65329942sarees
tamers84224032tamers
tames75242012tam_es
tramels93812492tramels
wames106432802wam_es
yamens114010822yamens

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.360496363.9
2DLD Change Limit825511162.59331836.1
3Display Results1161160.0462521.7
 (SQL Overall)1786911162.99959583.5
 
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.