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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 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
studio724713(None) 
studios8256641studios
audio62917102_audio
scudi85112162scudi_
scudo85412212scud_o
stadia7312142stadia
stucco1044252stucco
stud56220092stud__
studdie9195272studdie
studied9268692studied
studier82510052studier
studies82413862studies
studious9245552studious
studly10397692studly
studs64415872stud_s
study94411792stud_y
stupid937592stupid
audios72312283_audios
audit62527883_audit
boudin9412373boudin
cardio9915673cardio
curio74221213_curio
escudo943373escud_o
etude63612303etud_e
etudes73811603etudes
etui45416233etu_i_
etuis54013133etu_is
fugio9310923_fugio
judo125315303_jud_o
kudo96115113_kud_o
ludic82912803_ludic
nudie65118673_nudie
outdid81210923outdid
outdo6312703outd_o
pseudo934713pseud_o
ptui64912483ptu_i_
pudic104614563_pudic
radio64922493_radio
sadi55834643s_adi_
sadis64930853s_adis
scud76221283scud__
scuds85116243scud_s
skidoo1136093skidoo
sludge84811943sludge
sludgy11366253sludgy
smudge10387913smudge
smudgy13294133smudgy
sodic84917493s_odic
soldi65717203soldi_
soldo67116563sold_o
sordid83411163sordid
sordino8219443sordino
soudan73210353soudan
spadix1636113spadix
spado83713703spad_o
spud75818493spud__
spuds85113673spud_s
squib163710503squ_ib
squid154211903squ_id
squids16409803squids
stade64825303stad_e
stades74626243stades
stadias8411113stadias
stadium1038073stadium
staid66722083st_aid
staig65519643st_aig
stain55727943st_ain
stair54719943st_air
stasis63116873stasis
static83118683static
statin63921473statin
station72717243station
stein54620543st_ein
stelic8313083stelic
steno54716863st_eno
stereo65317913stereo
steric8317063steric
stingo74212163stingo
stinko10499393stinko
stir45723253st__ir
stoai55417873stoai_
stodge8369043stodge
stodgy11415733stodgy
stogie7311323stogie
stoic7317253st_oic
stolid74213183stolid
stotin63215063stotin
stourie7469353stourie
strain64919573strain
strait64025893strait
stria55723213st_ria
stride75420963stride
stridor8467393stridor
strip77524343st_rip
strudel835783strudel
stub66221843stu__b
stubby1345043stubby
stubs75016073stu_bs
stuccos1153933stuccos
stuck114515773stu_ck
studbook1542533studbook
studded10236873studded
studdies10207073studdies
studding1136703studding
student848343student
studfish1544523studfish
studiers9236623studiers
studlier935473studlier
studwork1643693studwork
studying1335553studying
stuff113817053stu_ff
stuffs123810223stuffs
stuffy15317083stuffy
stull54916273stu_ll
stulls63912983stulls
stum65526023stu__m
stump94616463stu_mp
stumps104912283stumps
stumpy13458133stumpy
stums75320083stu_ms
stun45623453stu__n
stung65417153stu_ng
stunk94616293stu_nk
stuns54719493stu_ns
stunt55328173stu_nt
stunts65615253stunts
stupa74112313stu_pa
stupas83910883stupas
stupe75217753stu_pe
stupes84116953stupes
stupids1035273stupids
stupor836013stupor
sturdied10215963sturdied
sturdier9216963sturdier
sturdies92110273sturdies
sturdily1245083sturdily
sturdy1037043sturdy
sturt56028963stu_rt
sturts63915143sturts
styli83911173styli_
stymie1137623stymie
subito8410453s_ubito
sudd64719773s_ud_d
sudds75513593s_udds
sudor6312623s_udor
suds56135293s_ud_s
sudsy95010683s_udsy
suit45649873s_u_it
sulfo8313363s_ulfo
sumo67326313s_u_mo
syndic1237303syndic
testudo843363testud_o
thio77225413_t_hio
trio45233343_t_rio
tsadi6379913tsadi_
tsadis7429133tsadis
tsuris62710203tsuris
tui37034023_tu_i_
tuis44829643_tu_is
tulip71111693_tulip
tumid84114023_tumid
tunic74018223_tunic
tupik1149003_tupik
turbo71015043_turbo
turion6313163_turion
udo49027303__ud_o

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161665.40620850.2
3Display Results1661660.0632634.9
 (SQL Overall)1786911665.84230587.3
 
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.