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

197 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
frankly1731563(None) 
crankly16358121crankly
rankly133910451_rankly
blankly1634262blankly
crackly18397702crackly
crankily1755622crankily
crankle133610062crankle
cranky153910632crank_y
crinkly16387522crinkly
dankly14419462_dankly
frailly1337312frailly
frank124417512frank__
franked153610052franked
franker143510182franker
franklin15104602franklin
franks134912732frank_s
freckly19124592freckly
grandly1238742grandly
lankly13439622_lankly
rankle103414882_rankle
wrinkly17295752wrinkly
ankle95220253__ankle
arrantly1156103arrantly
blackly1835253blackly
blandly1336043blandly
brainily1337313brainily
braky145015813bra_k_y
brambly16296253brambly
branchy17357913branchy
brandy124712063bran_dy
brank115222283brank__
branks124817383brank_s
branny115111833bran_ny
brashly15427613brashly
bravely15428233bravely
brawly144312353bra_wly
brawnily1644083brawnily
briskly16165403briskly
clanky15469073clank_y
crackle153611253crackle
cracky175010223crack_y
crank114819613crank__
cranked143812843cranked
cranker133612793cranker
crankled15408153crankled
crankles143510153crankles
cranks125015313crank_s
cranny114210273cran_ny
crassly1276653crassly
crawly144610763cra_wly
crazily2136923crazily
crinkle13359413crinkle
dangly114212263_dangly
darkly145411073_darkly
dinkly144311083_dinkly
drably123511613dra_bly
drank104816203drank__
drawly134910723dra_wly
errantly1175793errantly
faintly1337083faintly
fairly125610013f_airly
fakey155515423f_a_key
family143311703f_amily
fancily1538253f_ancily
fancy134615483f_an_cy
fanny114816043f_an_ny
fatly115716803f_a_tly
featly123711753fea_tly
feckly18335963f_eckly
fickly18318533f_ickly
finally13310103finally
finely123011563f_inely
flakey164410513fla_key
flakily1736293flakily
flaky155715583fla_k_y
flank124618093flank__
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flanks133913403flank_s
flatly123110213fla_tly
flunkey17405793flunkey
flunky16408093flunk_y
foamily1546543foamily
fondly13299043f_ondly
fragile1147843fragile
frail85220213fra_il_
frails93716473fra_ils
frailty1335663frailty
franc104615413fran__c
francs114112193fran_cs
frankable1844923frankable
frankers15348353frankers
frankest1536963frankest
franking164310863franking
franklins1694763franklins
frantic12310373frantic
franticly1744013franticly
fray105428903fra___y
frazil1847223frazil_
frazils1956123frazils
frazzle18305223frazzle
freakily1835003freakily
freaky16439233freak_y
freckle16106643freckle
freely12310963fr_eely
frenula1045623frenula
frenzily2343733frenzily
frenzy2135883fren_zy
freshly16286833freshly
friarly13316213friarly
friendly1544383friendly
frilly124111443fr_illy
fringy13309263frin_gy
friskily1834503friskily
frisky16406673frisk_y
frizzly21455793frizzly
funkily1736513f_unkily
funky154315133f_unk_y
funnily1336373funnily
gangly113911583_gangly
grackle14338893grackle
granary1157793granary
granny104311163gran_ny
granola837913granola
granule839473granule
gravely14469063gravely
grayly13287963gra_yly
hackly18298733_hackly
hanky155418293_hank_y
inanely1037943inanely
irately1047683irately
jangly174310603_jangly
lanely93914483_lanely
lankily1437123_lankily
lanky125517483_lank_y
leanly93811503lean_ly
manly105022953_man_ly
meanly115412043mean_ly
orally93113593ora_lly
orangey11388833orangey
orangy105111233oran_gy
packly17228333_packly
pinkly155012243_pinkly
prank115019453prank__
pranked143712093pranked
pranks124814723prank_s
prickly18367893prickly
pronely12310253pronely
racily11715173_racily
rackle123917293_rackle
rainily10310433_rainily
rally84725903_ra_lly
randy95022083_ran_dy
rangy95320383_ran_gy
rank85135533_rank__
ranked114620743_ranked
ranker105021903_ranker
rankled123910653_rankled
rankles113114543_rankles
ranks95225733_rank_s
ranula6311813_ranula
raptly11338913_raptly
rarely93513653_rarely
rashly123410213_rashly
rattly94111543_rattly
rawly115115833_ra_wly
riantly1037613riantly
runkle103611543_runkle
sanely93114613_sanely
scantly12419553scantly
skanky12476963skank_y
slackly1635263slackly
slantly10399323slantly
spangly1336473spangly
sparkly16348133sparkly
starkly14277033starkly
swankily1833833swankily
swanky16447973swank_y
tangly104413913_tangly
tinkly134811153_tinkly
trank96222423trank__
tranks104017763trank_s
tranny94210863tran_ny
trickly16369893trickly
truantly1144643truantly
twanky16445773twank_y
twinkly1733913twinkly
uranyl936293uranyl_
uranyls1034453uranyls
urbanely1343693urbanely
wanly115118023_wan_ly
weakly1636483wea_kly
wrangle1137383wrangle
wrinkle14296923wrinkle
wrongly1434553wrongly
zanily18310183_zanily

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271976.47020715.1
3Display Results1971970.0762592.1
 (SQL Overall)1786911976.95225703.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.