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

207 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
risk8572410(None) 
bisk106523351bisk
brisk115615981brisk
disk96625831disk
frisk125312371frisk
rick107334651rick
rink87736991rink
rise45945231rise
risks94917061risks
risky126311521risky
rusk85823311rusk
ais39083572ais_
arise56436432arise
ask77130702_ask
bask105131422bask
bilk105824422bilk
birk106326862birk
bis56860662bis_
bise66437102bise
bisks115416802bisks
bosk105825732bosk
brick134618152brick
brink116122002brink
bris65539612bris_
brisks124611402brisks
briss75824272briss
brusk114912432brusk
busk105429222busk
cask105626432cask
cis57748032cis_
cist67244962cist
crick135118752crick
cris66233432cris_
crisp95014622crisp
cusk105521632cusk
desk95618902desk
dick116432382dick
dink97137802dink
dirk96326832dirk
dis46459892dis_
disc76123232disc
dish86328332dish
disks105417472disks
diss56434482diss
drink106816382drink
dusk95724152dusk
fink117532122fink
fisc96819752fisc
fish106926272fish
fist76248422fist
frise85322452frise
frisks13479262frisks
frisky16406672frisky
gink97129522gink
gist56046762gist
grist65529872grist
hick135530302hick
his66359502his_
hisn79620932hisn
hiss75629212hiss
hist76551542hist
husk116021952husk
ick97329322_ick
ilk78325302_ilk
ink76433632_ink
iris45732552iris_
irk76426362_irk
irks86220132irks
is27048212_is_
ism56322382_ism
jink156227202jink
jism135514772jism
kick96026072kick
kink76034402kink
kiosk836232kiosk
kirk76221572kirk
kis78051482kis_
kiss85227402kiss
kist86540802kist
kris86423602kris_
lick106935072lick
link86943442link
lis37162272lis_
lisp68926882lisp
list47055342list
mask105227362mask
mick126333432mick
milk105028472milk
mink106636532mink
mirk106729502mirk
mis58162622mis_
mise66043582mise
miso67229902miso
miss65339422miss
mist66154532mist
mosk105622442mosk
musk104526192musk
nick106627602nick
nisi45823242nisi
oink85429342oink
pick125933812pick
pink107039382pink
pis56362032pis_
pish96127912pish
piso66727562piso
piss65033332piss
prick134317502prick
prink114719672prink
prise74632612prise
prism94820262prism
priss74623892priss
qis126934382qis_
rack106234882rack
rais45252622rais_
raise54828052raise
rank85135532rank
ras37575392ras_
rase46149982rase
rash76039932rash
rasp66029162rasp
reck106130562reck
reek85232522reek
reink95518092reink
reis45343232reis_
res35565042res_
resh76523452resh
rest46459842rest
ria36745502ri_a
rial45938092rial
rias45540592rias
rib56848032ri_b
ribs65833022ribs
rice64942912rice
rich97025542rich
ricks115126132ricks
rid46754632ri_d
ride55945132ride
rids56539552rids
riel46432382riel
rif65951562ri_f
rife74632322rife
riff104430102riff
rifs74929002rifs
rift75642332rift
rig46748122ri_g
rigs55137592rigs
rile45650532rile
rill45140902rill
rim56052272ri_m
rime65138882rime
rims65936302rims
rimy96621282rimy
rin36663182ri_n
rind56535602rind
ring56541152ring
rinks94827102rinks
rins46153192rins
rinse54820972rinse
riot45947212riot
rip56851302ri_p
ripe66038922ripe
rips66237432rips
risen54621882risen
riser55431052riser
rises55244042rises
rishi8311252rishi
risked115514632risked
risker105414492risker
risus54216392risus
rite45849452rite
ritz135129982ritz
rive75537722rive
rock105735182rock
rook85532032rook
rose46148902rose
rosy76024872rosy
ruck104728332ruck
ruse45938932ruse
rush76628182rush
rusks95816192rusks
rust45544912rust
sick106435572sick
silk85529322silk
sink86640142sink
sis37360542sis_
sris45434152sris_
task85326652task
tick106231222tick
tis37056642tis_
trick115420692trick
tsk75814732_tsk
tusk85621632tusk
vis66747612vis_
visa76323872visa
vise75632672vise
whisk154510142whisk
wick135726302wick
wink116435022wink
wis66552332wis_
wise75737342wise
wish107228732wish
wisp97124072wisp
wiss75630542wiss
wist78049292wist
wrick144013392wrick
wrist84827562wrist
xis106935332xis_

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.440406115.9
2DLD Change Limit298722070.89033564.0
3Display Results2072070.0464500.0
 (SQL Overall)1786912071.376129862.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.