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

139 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
studios825664(None) 
studies82413861studies
studio7247131studio_
studious9245551studious
audios72312282_audios
stadias8411112stadias
stuccos1153932stuccos
studdies10207072studdies
studied9268692studied
studier82510052studier
studiers9236622studiers
studs64415872stud__s
stupids1035272stupids
sturdies92110272sturdies
adios65822863__adios
audio62917103_audio_
audits72814113_audits
boudins10311313boudins
curios83218333_curios
escudos1043493escud_os
etudes73811603etud_es
etuis54013133etu_i_s
fugios1037583_fugios
gaudies9311973gaudies
judos134711733_jud_os
kudos105011253_kud_os
nudies75217093_nudies
pseudos1044833pseud_os
radios74018673_radios
restudies10156033restudies
sadis64930853s_adi_s
sardius839553sardius
sauries72821623sauries
scudi85112163scudi__
scudo85412213scud_o_
scuds85116243scud__s
skidoos1234463skidoos
sludges93811993sludges
smudges11348283smudges
soddies92312853soddies
soudans8309353soudans
spuds85113673spud__s
spurious1036963spurious
squibs17317453squ_ibs
squids16409803squ_ids
stades74626243stad_es
stadia7312143stadi_a
stadium1038073stadium
stadiums1145703stadiums
staigs75414813st_aigs
stains64923653st_ains
stairs65416333st_airs
stasis63116873stasi_s
statics93314533statics
statins73719773statins
station72717243station
stations82415223stations
steadies9311123steadies
steins64818343st_eins
stenos63915773st_enos
stereos74314973stereos
sties55132983st__ies
stimies9316563stimies
stingos8459453stingos
stirs55921623st__irs
stodges9309083stodges
stogies8413693stogies
stoics8311113st_oics
stories7324273stories
stotins73213873stotins
strains74218153strains
straits74916323straits
strides84520393strides
stridor8467393stridor
stridors9367323stridors
strips85719653st_rips
strudels934123strudels
stubs75016073stu__bs
stucco1044253stucco_
stuccoes1254273stuccoes
stud56220093stud___
studbook1542533studbook
studbooks1652463studbooks
studded10236873studded
studdie9195273studdie
studding1136703studding
studdings1242933studdings
student848343student
students954683students
studfish1544523studfish
studhorse1342033studhorse
studiously1454843studiously
studlier935473studlier
studliest1036573studliest
studly10397693stud_ly
studwork1643693studwork
studworks1743673studworks
study94411793stud__y
studying1335553studying
stuffs123810223stu_ffs
stulls63912983stu_lls
stumps104912283stu_mps
stums75320083stu__ms
stuns54719493stu__ns
stunts65615253stu_nts
stupas83910883stu_pas
stupes84116953stu_pes
stupid937593stupi_d
stupor836013stu_por
stupors935883stupors
sturdied10215963sturdied
sturdier9216963sturdier
sturdiest10207393sturdiest
sturdily1245083sturdily
sturts63915143stu_rts
stymies1239213stymies
sudds75513593s_ud_ds
sudor6312623s_ud_or
sudors7311103s_udors
suds56135293s_ud__s
sudses74114503s_udses
suits55028053s_u_its
sumos75720093s_u_mos
syndics1335703syndics
tedious838443_tedious
testudos943053testud_os
tidies74721833_tidies
todies74223553_todies
trios55528093_t_rios
tsadis7429133tsadi_s
tsuris62710203tsuri_s
tuis44829643_tu_i_s
tulips8137253_tulips
tunics83811263_tunics
tupiks1235493_tupiks
turbos8910783_turbos
turion6313163_turion
turions7311573_turions
udos56619903__ud_os

Search took 9 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 Filter1786911340270.483369960.7
2DLD Change Limit1340271397.59317651.4
3Display Results1391390.0463021.7
 (SQL Overall)1786911398.12222000.9
 
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.