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

232 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
riot4594721(None) 
griot65328411griot
rift75642331rift
riots54922011riots
root45655921root
rot37282951r_ot
ryot75528561ryot
airt45757782airt
ait38093902ai_t
argot67728652argot
bigot84828322bigot
bint67355042bint
bio57846082bio_
biog76122322biog
biont7727162biont
bios66335322bios
biota74516822biota
bit57070902bi_t
bitt65545812bitt
blot65842322blot
boot67759372boot
bot59680402_bot
brio65432492brio_
brios74725722brios
brit66350152bri_t
britt75732232britt
cion613330912cion
cist67244962cist
clot66542422clot
coot67860382coot
cot510483222_cot
crit65743712cri_t
dicot85429092dicot
diet57357532diet
dint56759052dint
diol57329132diol
dipt77339322dipt
dirt55550382dirt
dit47071332di_t
divot95723072divot
doit56347852doit
dot47573182_dot
drift95722842drift
dript86923872dript
droit65127122droit
ergot65422892ergot
fiat76646642fiat
fist76248422fist
fit66365452fi_t
fixt1410729712fixt
foot76248012foot
frit77044472fri_t
fritt86129412fritt
gift86735792gift
gigot74023072gigot
gilt56348542gilt
girt56646422girt
gist56046762gist
git46266052gi_t
got49870442_got
grift95924462grift
griots74713642griots
gript85126172gript
grist65529872grist
grit55247242gri_t
grot55942052grot
heriot9422342heriot
hilt75850712hilt
hint77455742hint
hist76551542hist
hit66569192hi_t
hoot75752102hoot
hot67776062_hot
idiot6718862idiot
ion36051022_ion
iota45127832_iota
iron46728462iron
it28455682_i_t
jilt115839422jilt
jot108259022_jot
kilt86144422kilt
kist86540802kist
kit78559882ki_t
knot85630502knot
lift76942722lift
lilt46349942lilt
lint416266232lint
lion46334442lion
lirot5430032lirot
list47055342list
lit39377312li_t
loot46955822loot
lot38179262_lot
milt65455812milt
mint66758062mint
mist66154532mist
mitt66145492mitt
mixt136831922mixt
moot67653622moot
mot57279422_mot
nit37065942ni_t
not39474662_not
oot311274692_oot
phot95534362phot
picot95031012picot
pilot77435062pilot
pinot78737292pinot
pint66963172pint
pion67235292pion
pit56471922pi_t
pivot106523872pivot
plot66141232plot
pot58078432_pot
print74837462print
prion75119992prion
prior74316172prior
raft76245912raft
rant45864682rant
rapt67245312rapt
rat37892742r_at
rato45436972rato
reft75141272reft
rent46661242rent
repot75132622repot
rest46459842rest
ret35982832r_et
rho65924832rho_
rhos76319062rhos
ria36745502ri_a
rial45938092rial
riant55833152riant
rias45540592rias
riata54618022riata
rib56848032ri_b
ribs65833022ribs
rice64942912rice
rich97025542rich
rick107334652rick
rid46754632ri_d
ride55945132ride
rids56539552rids
riel46432382riel
rif65951562ri_f
rife74632322rife
riff104430102riff
rifs74929002rifs
rifts85718642rifts
rig46748122ri_g
right94430502right
rigor62714052rigor
rigs55137592rigs
rile45650532rile
rill45140902rill
rim56052272ri_m
rime65138882rime
rims65936302rims
rimy96621282rimy
rin36663182ri_n
rind56535602rind
ring56541152ring
rink87736992rink
rins46153192rins
rioja1236302rioja
rioted73416372rioted
rioter64817282rioter
rip56851302ri_p
ripe66038922ripe
ripost83615002ripost
rips66237432rips
rise45945232rise
risk85724102risk
rite45849452rite
ritz135129982ritz
rive75537722rive
rivet85636362rivet
rob56754302r_ob
robot7325972robot
roc520243252r_oc
rod47953892r_od
roe36861082r_oe
roil46235292roil
rom59855632r_om
rood56733002rood
roof75738832roof
rook85532032rook
room66235082room
roost55730932roost
roots55933672roots
rooty86423022rooty
rota45834342r_ota
rote46249022r_ote
roti46332932r_oti
rotl45029682r_otl
roto45935052r_oto
rots46454092r_ots
rout46153282rout
row67453672r_ow
runt46647992runt
rust45544912rust
rut35560522r_ut
ryots85313782ryots
scot66242612scot
shot76150262shot
sift710740662sift
silt46558192silt
sit35877752si_t
slot46049832slot
snot44745452snot
soot45761062soot
sot310384302_sot
spot65540692spot
stot46347332stot
swot75134662swot
tilt46252422tilt
tint46758862tint
tit36771052ti_t
toit46353062toit
toot45958882toot
tot38884772_tot
tricot8317752tricot
trio45233342trio_
triol55521362triol
trios55528092trios
trot46351312trot
viol76523592viol
wilt76246292wilt
wist78049292wist
wit66563772wi_t
wot610467482_wot
wrist84827562wrist
writ75537912wri_t
zit126049992zi_t

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.283631417.0
2DLD Change Limit298722320.89033564.0
3Display Results2322320.0633682.5
 (SQL Overall)1786912321.236144572.0
 
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.