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 “drank” 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
drank10481620(None) 
brank115222281brank
crank114819611crank
dank95828241d_ank
drink106816381drink
drunk10549841drunk
frank124417511frank
prank115019451prank
rank85135531_rank
trank96222421trank
arak86929572ara_k
bank105835752_bank
blank115418552blank
bran65740382bran_
brand85124492brand
branks124817382branks
brans75437432brans
brant74742172brant
brink116122002brink
clank114719522clank
crack134120532crack
crane75331602crane
cranks125015312cranks
cranky153910632cranky
dak86340692d_a_k
dan46859672d_an_
dang65131542d_ang
dans56748152d_ans
dark95133212d_ark
darn56434622darn_
darns66927892darns
dawk126117282d_awk
dean56039482dean_
deans66131392deans
dhak125512032dha_k
dink97137802d_ink
drab76226452dra_b
drabs85119672drabs
draff125615662draff
draft95526682draft
drag64825052dra_g
drags75521112drags
drail65020972drail
drain65222892drain
drains73719402drains
drake104918302drake
dram75832002dra_m
drama85117412drama
drams86025832drams
drape85319632drape
drat56247832dra_t
drats66628372drats
drave95219272drave
draw85623012dra_w
drawl95516012drawl
drawn95614242drawn
draws95119372draws
dray85428092dra_y
drays95819772drays
dreck124812802dreck
drek96321092dr_ek
drinks116810712drinks
drone65324982drone
drouk1039432drouk
drunks11427512drunks
dunk96228572d_unk
flank124618092flank
franc104615412franc
franks134912732franks
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.310576422.6
2DLD Change Limit538001091.58034050.6
3Display Results1091090.0303633.3
 (SQL Overall)1786911091.92093068.2
 
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.