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

310 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
rank8513552(None) 
bank105835741bank
brank115222281brank
crank114819611crank
dank95828231dank
drank104816201drank
frank124417511frank
hank115134131hank
lank84734441lank
prank115019451prank
rack106234881rack
ran38266611ran_
rand55839561rand
rang56939151rang
rani46640101rani
ranks95225731ranks
rant45864671rant
rink87736991rink
sank85236821sank
tank85134011tank
trank96222421trank
wank115632501wank
yank115423661yank
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
ani37751172_ani
ankh111114412_ankh
ant37270782_ant
any68440482_any
arak86929572arak
ark77044962_ark
ask77130702_ask
auk76234142_auk
back125535762back
balk105132222balk
ban58366832ban_
band76740902band
bane65250422bane
bang74836992bang
bani65334952bani
banks115527902banks
bans66555132bans
bark106242152bark
bask105131422bask
blank115418552blank
bonk105531712bonk
bran65740382bran_
brand85124492brand
branks124817382branks
brans75437432brans
brant74742172brant
brink116122002brink
bunk105731352bunk
calk105527662calk
can57760132can_
cane66653112cane
cans65050842cans
cant66362022cant
cark105539272cark
cask105626432cask
clank114719522clank
conk106531442conk
crack134120532crack
crane75331602crane
cranks125015312cranks
cranky153910632cranky
dak86340692da_k
dan46859662dan_
dang65131532dang
dans56748142dans
dark95133212dark
dawk126117282dawk
dink97137802dink
drink106816382drink
drunk10549842drunk
dunk96228572dunk
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fink117532122fink
flank124618092flank
franc104615412franc
franks134912732franks
funk115825622funk
gan48060122gan_
gane55145292gane
gang66031962gang
gawk126716692gawk
gink97129522gink
gran56335012gran_
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
gunk95423572gunk
hack135134542hack
haik115526982haik
hand86833702hand
hang85535542hang
hanks126226862hanks
hanky155418292hanky
hant75461582hant
hark115237392hark
hawk145521152hawk
honk116931192honk
hunk116029542hunk
ink76433632_ink
jack175224862jack
jane115031472jane
jauk155816092jauk
jink156227202jink
junk155121032junk
kana85928522kana
kane85133962kane
kink76034392kink
konk79320612konk
lack105837682lack
land56337302land
lane45153322lane
lang56637372lang
lanky125517482lanky
lark85733862lark
link86943442link
lunk86030722lunk
mack125733642mack
man57465852man_
mana65341942mana
mane65052012mane
mano66536792mano
mans66354532mans
many95731842many
mark105138052mark
mask105227352mask
mink106636512mink
monk105928512monk
nan37854872nan_
nana46632892nana
nans46139392nans
nark85230062nark
oak76238652oa_k
oink85429342oink
orang65119942orang
pack125535442pack
paik105726802paik
pan58466442pan_
pane64950282pane
pang75336282pang
pans65855722pans
pant66061252pant
park105237492park
pink107039382pink
plank115221142plank
prang84820322prang
pranks124814722pranks
prink114719672prink
punk105729972punk
race66746262race
racks115028852racks
racy95825682racy
rad47662002ra_d
rads56046602rads
raff104933042raff
raft76245912raft
rag45761322ra_g
raga55930812raga
rage55742352rage
ragg65622692ragg
ragi56032282ragi
rags55448372rags
rah68052402ra_h
rai37658222ra_i
raia46638382raia
raid55243072raid
rail46147762rail
rain46251732rain
rains55140232rains
rainy85921082rainy
rais45252622rais
raj105740222ra_j
raja117918682raja
rake84841572rake
raki87127832raki
raku85423772raku
rale45050562rale
ram56867272ra_m
rami66034092rami
ramp85934002ramp
rams65950772rams
rance75028512rance
ranch105019792ranch
rands65930452rands
randy95022082randy
ranee55438102ranee
range64728412range
rangy95320382rangy
ranid66429332ranid
ranis55235832ranis
ranked114620742ranked
ranker105021902ranker
rankle103414882rankle
rankly133910452rankly
rants55935342rants
rap56261962ra_p
rape65041632rape
raps66247732raps
rapt67245312rapt
rare45348432rare
ras37575392ra_s
rase46149982rase
rash76039932rash
rasp66029162rasp
rat37892742ra_t
rate45458762rate
rath76037662rath
rato45436972rato
rats46260372rats
rave75542092rave
raw67252252ra_w
raws75238212raws
rax108445722ra_x
ray66361992ra_y
raya75224822raya
rays77642352rays
raze135235432raze
razz125219422razz
reck106130562reck
reek85232522reek
reink95518092reink
rend56136572rend
rent46661242rent
riant55833152riant
rick107334652rick
rin36663182rin_
rind56535602rind
ring56541152ring
rinks94827102rinks
rins46153192rins
risk85724102risk
roan47234202roan_
roans54926442roans
rock105735182rock
rook85532032rook
ruana5312422ruana
ruck104728332ruck
run36244982run_
rune45236292rune
rung56429972rung
runs46438072runs
runt46647982runt
rusk85823312rusk
rynd86414102rynd
sack105337312sack
sand55338462sand
sane45954332sane
sang55441222sang
sans45153352sans
sark84938972sark
shank125422192shank
shrank13359122shrank
sink86640142sink
skank84415582skank
slank95822772slank
spank115919572spank
stank95823302stank
sunk85031812sunk
swank125318232swank
tack106536292tack
talk86230092talk
tan37167562tan_
tang56138662tang
tanka93817482tanka
tanks94624732tanks
tans46154812tans
task85326652task
thank125817802thank
track114823012track
traik95418202traik
tranks104017762tranks
tranq145416892tranq
trans54933042trans
trunk94713042trunk
van66246322van_
vane75534682vane
vang84926032vang
vans76236722vans
wack135330912wack
walk115625612walk
wan66761932wan_
wand85833872wand
wane76344712wane
wanks126124482wanks
wans76452262wans
want76156162want
wany106432352wany
wark115737772wark
wauk115220592wauk
wink116435022wink
wonk116125302wonk
wrack145413882wrack
wrang94716112wrang
yack135425972yack
yak107038562ya_k
yang85626062yang
yanks125316572yanks
zany167316982zany
zonk175018622zonk

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 Filter178691298720.0802233637.5
2DLD Change Limit298723100.98330388.6
3Display Results3103100.0803875.0
 (SQL Overall)1786913101.143156335.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.