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

150 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
rakee9603117(None) 
akee85936811_akee
ragee65432661ragee
rake84841571rak_e
raked105831421raked
rakees104516971rakees
raker94529791raker
rakes94440351rakes
ramee74633851ramee
ranee55438101ranee
razee145827801razee
ackee115825362ackee
agee56241492_agee
ajee115928232_ajee
akees96119242_akees
akene95818662_akene
alee46652322_alee
awee76336642_awee
bake105637512bak_e
baked126130772baked
baker115629542baker
bakes117035372bakes
brake116025342brak_e
braked135318692braked
brakes124923122brakes
cake105439962cak_e
caked126128622caked
cakes116037672cakes
cakey145517272cakey
crake114823522crak_e
crakes124921812crakes
dragee84415602dragee
drake104918302drak_e
drakes114715862drakes
drawee104413822drawee
fake115534942fak_e
faked135225482faked
fakeer13378742fakeer
faker124824592faker
fakes126032482fakes
fakey155515422fakey
hackee154921832hackee
hake115637842hak_e
hakeem15407382hakeem
hakes126034302hakes
jake155925772jak_e
jakes165023642jakes
kraken955882kraken
lake85741602lak_e
laked105731122laked
laker95432872laker
lakes95737652lakes
laree56036292laree
make105537882mak_e
maker114127812maker
makes115336852makes
naked105320852naked
oaken95814382oaken
payee105524722payee
race66746262ra_ce
raced87635312raced
raceme1039732raceme
racer75233022racer
races74943242races
racked134526082racked
racker124824552racker
racket125229422racket
rackle123917292rackle
rage55742352ra_ge
raged74829452raged
ragees74618662ragees
rages64539442rages
raggee84217602raggee
raise54828052raise
rajes125022782rajes
rakers104123572rakers
raki87127832rak_i
rakis95323442rakis
raku85423772rak_u
rakus94413672rakus
rale45050562ra_le
rales54947492rales
ramees84620892ramees
ramen75625192ramen
ramet75743142ramet
ramie75027822ramie
rance75028512rance
ranees64623962ranees
range64728412range
ranked114620742ranked
ranker105021902ranker
rankle103414882rankle
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
ree37974072r__ee
rekey124014732rekey
resee54336332resee
rupee7321282rupee
ryke115616402ryk_e
ryked13669512ryked
rykes125513032rykes
sake85244962sak_e
saker95132022saker
sakes95540752sakes
saree55044662saree
skee85431472_skee
take84739262tak_e
taken94819142taken
taker95229002taker
takes94437792takes
vakeel1335192vakeel
wake114935702wak_e
waked135626752waked
waken124818472waken
waker125526592waker
wakes126633652wakes

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.1701051123.5
2DLD Change Limit538001502.20324421.2
3Display Results1501500.0334545.5
 (SQL Overall)1786911502.40674268.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.