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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
trunk9471304(None) 
drunk10549841drunk
thunk124911851thunk
trank96222421trank
truck116115461truck
trunks10429751trunks
brank115222282brank
brink116122002brink
brung84613912brung
brunt75728752brunt
brusk114912432brusk
bunk105731352_bunk
chunk144812382chunk
clunk114215082clunk
crank114819612crank
cruck135615322cruck
drank104816202drank
drink106816382drink
drunks11427512drunks
dunk96228572_dunk
flunk125014382flunk
frank124417512frank
funk115825622_funk
grunt65523542grunt
gunk95423572_gunk
hunk116029542_hunk
junk155121032_junk
lunk86030722_lunk
plunk114514402plunk
prank115019452prank
prink114719672prink
prune75119632prune
punk105729972_punk
rank85135532_rank
rink87736992_rink
ruck104728332_ruck
run36244992_run_
rune45236302_rune
rung56429982_rung
runs46438082_runs
runt46647992_runt
rusk85823312_rusk
shrunk13357062shrunk
skunk85011762skunk
slunk95016302slunk
spunk114513402spunk
struck12489262struck
strung75213022strung
strunt64918912strunt
stunk94616292stunk
sunk85031812_sunk
tank85134022t_ank
taunt55532282taunt
thank125817802thank
think125018802think
thunks13459032thunks
track114823012track
traik95418202traik
tranks104017762tranks
tranq145416892tranq
trans54933042trans
trek86222312tr_ek
trend64817452trend
trick115420692trick
trine54734602trine
triune64210182triune
troak95213572troak
trock114817602trock
trona54118952trona
trone55131862trone
truant6315782truant
truce75118692truce
trucks124711972trucks
true46725852tru_e
trued65117692trued
truer54916642truer
trues54925322trues
trug55720042tru_g
trugs65516802trugs
truing73913932truing
trull54012672trull
truly84111552truly
trump95615122trump
trunked12358412trunked
truss54916922truss
trust55426852trust
truth85214152truth
tuck104626572t_uck
tun35845192t_un_
tuna45127842t_una
tune45635862t_une
tung55328162t_ung
tuns45138662t_uns
turk86125862t_urk
turn46330392turn_
turns55623242turns
tusk85621632t_usk
wrung9549802wrung

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.313570897.8
2DLD Change Limit53800981.56334421.0
3Display Results98980.0303266.7
 (SQL Overall)178691981.90693751.8
 
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.