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 “frankest” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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
frankest153696(None) 
crankest1438141crankest
rankest112713811_rankest
blankest14439062blankest
crankiest1538822crankiest
dankest122611672_dankest
drunkest1334422drunkest
frailest1139492frailest
franked153610052franke_d
franker143510182franke_r
frankers15348352frankers
frankness1655222frankness
franks134912732frank_s_
grandest10311572grandest
lankest112714112_lankest
swankest15105932swankest
anankes1138763anankes_
barniest104815053barniest
blackest16269303blackest
blandest113811043blandest
blanket134313093blanke_t
blankets14356503blankets
bracket154117233bracke_t
brackets163310433brackets
braggest1296533braggest
brainiest11209723brainiest
brakes124923123bra_kes_
brakiest143912243brakiest
branks124817383brank_s_
branniest11199383branniest
brashest133511763brashest
bravest124211753bra_vest
brawest123810483bra_west
brawniest14197103brawniest
briniest102812323briniest
briskest14337803briskest
bruskest14315903bruskest
clankiest1536663clankiest
crakes124921813cra_kes_
cranes84330753cran_es_
cranked143812843cranke_d
cranker133612783cranke_r
crankish1736513crankish
crankles143510153crankles_
cranks125015313crank_s_
crassest103411523crassest
craziest19319923craziest
crookest1436683crookest
darkest122512623_darkest
darndest1067223darndest
drabbest13295663drabbest
drakes114715863dra_kes_
earnest7318733earn_est
fabbest1438033f_abbest
fainest10417703f_ainest
faintest1139073faintest
fairest10412293f_airest
fakes126032483f_a_kes_
falsest10310013f_alsest
fanciest133612713f_anciest
fanes84639893f_an_es_
fanjet16311393f_anje_t
fanjets1734803f_anjets
fantast10311703f_antast
farness102912203farn_ess
farthest1499863farthest
fastest102413723f_astest
fattest102913063f_attest
fawniest14287443fawniest
featest102715113fea_test
fenniest113113203fenniest
ferniest1132214153ferniest
fiances12310673fiances_
finest94321733f_in_est
finniest113011403finniest
flakes134118873fla_kes_
flakiest153210543flakiest
flamiest133111973flamiest
flanes94522423flan_es_
flanges113413273flanges_
flanked153710643flanke_d
flanken14226763flanke_n
flanker143911293flanke_r
flankers15349303flankers
flanks133913403flank_s_
flasket1439733flaske_t
flaskets1534603flaskets
flattest1138713flattest
flawiest14298573flawiest
flaxiest18298183flaxiest
foamiest13289853foamiest
fondest11312403f_ondest
fragment1448373fragment
fraises104215693fraises_
frames115119863fra_mes_
francs114112193fran_cs_
frank124417513frank___
frankfort1952673frankfort
frankfurt1951973frankfurt
franking164310863franking
franklin15104603franklin
frankly17315633frank_ly
frappes14328383frappes_
frasses104314513frasses_
freakiest16206693freakiest
freest95318283fr__eest
freshest143010583freshest
fringes113514103fringes_
fringiest1347603fringiest
frisket143811773friske_t
friskets15326263friskets
friskiest1636233friskiest
frontes104214163frontes_
funest94316863f_un_est
funfest13348083f_unfest
funkiest152810973f_unkiest
funnest102912003f_unnest
funniest113010733funniest
furanes103214863furan_es_
grainiest10188993grainiest
granges93516523granges_
grapiest112211923grapiest
gravest114011633gra_vest
grayest11489363gra_yest
inanest72115363inan_est
iratest7312483ira_test
lankiest122912493_lankiest
leanest7415863lean_est
meanest9315703mean_est
oranges84215333oranges_
orangiest1038463orangiest
pinkest132812623_pinkest
prances113618773prances_
pranked143712093pranke_d
prankish1737023prankish
pranks124814723prank_s_
punkest132611693_punkest
raciest92820013_raciest
racket125229423_racke_t
rackets134916873_rackets
rainiest81214923_rainiest
rakes94440353_ra_kes_
rances84625443_rances_
randiest93418773_randiest
ranees64623963_ranees_
ranges73826923_ranges_
rangiest93115983_rangiest
ranked114620743_ranke_d
ranker105021903_ranke_r
rankers113217463_rankers
rankish14510383_rankish
rankles113114543_rankles_
rankless12268233_rankless
rankness12267943_rankness
ranks95225733_rank_s_
rarest65725483_ra_rest
rashest103916873_rashest
rawest93615063_ra_west
renest64529713_ren_est
sanest64426693_san_est
scantest101710183scantest
skankiest12145703skankiest
slackest14289393slackest
starkest1239723starkest
strangest103210843strangest
swankiest16136203swankiest
tannest72617853_tannest
trances93919643trances_
tranks104017763trank_s_
transect10410053transect
transept1048633transept
trapnest10310923trapnest
trinket11314813trinke_t
trinkets1237143trinkets
urbanest10117533urban_est
wackest164710863_wackest
waniest103819113_waniest
wannest103915003_wannest
weakest1439003wea_kest
wrongest1236733wrongest
zaniest163214773_zaniest

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621817.57619292.8
3Display Results1811810.0802262.5
 (SQL Overall)1786911817.81222873.9
 
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.