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

109 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
frank12441751(None) 
brank115222281brank
crank114819611crank
drank104816201drank
flank124618091flank
franc104615411franc
franks134912731franks
prank115019451prank
rank85135531_rank
trank96222421trank
arak86929572ara_k
bank105835752_bank
blank115418552blank
bran65740382bran_
brand85124492brand
branks124817382branks
brans75437432brans
brant74742172brant
brink116122002brink
clank114719522clank
crack134120532crack
crane75331602crane
cranks125015312cranks
cranky153910632cranky
dank95828242_dank
drink106816382drink
drunk10549842drunk
fan67158862f_an_
fane75343572f_ane
fang85432552f_ang
fano75831692f_ano
fans76247372f_ans
fink117532122f_ink
flack144519412flack
flak116026172fla_k
flan76134182flan_
flanks133913402flanks
flans85327972flans
flask125512422flask
flunk125014382flunk
frae75330472fra_e
fraena938062fraena
frag85126272fra_g
frags96322172frags
frail85220212frail
frame105821802frame
francs114112192francs
franked153610052franked
franker143510182franker
frankly17315632frankly
frap95925812fra_p
fraps105620552fraps
frass85321122frass
frat75648542fra_t
frats86829672frats
fraud939862fraud
fray105428902fra_y
frays116920102frays
freak125115242freak
frena85915272frena
frisk125312372frisk
frock145314652frock
frond95316342frond
frons86124042frons
front85029222front
funk115825622f_unk
furan84320012furan_
furane94015492furane
furans94515952furans
gran56335012gran_
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
hank115134142_hank
lank84734452_lank
orang65119942orang
plank115221142plank
prang84820322prang
pranks124814722pranks
prink114719672prink
rack106234882_rack
ran38266622_ran_
rand55839572_rand
rang56939162_rang
rani46640112_rani
ranks95225732_ranks
rant45864682_rant
rink87736992_rink
sank85236832_sank
shank125422192shank
shrank13359122shrank
skank84415582skank
slank95822772slank
spank115919572spank
stank95823302stank
swank125318232swank
tank85134022_tank
thank125817802thank
track114823012track
traik95418202traik
tranks104017762tranks
tranq145416892tranq
trans54933042trans
trunk94713042trunk
wank115632512_wank
wrack145413882wrack
wrang94716112wrang
yank115423672_yank

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.296603685.8
2DLD Change Limit538001091.56334421.0
3Display Results1091090.0303633.3
 (SQL Overall)1786911091.88994595.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.