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

196 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
dirndl83425(None) 
dirndls933891dirndls
darnel74312182darnel
dindle84417222di_ndle
dirl57430032dir__l
diurnal844882diurnal
aired66032923aired_
airn46433843airn__
airns55521033airn_s
binal75323823bi_nal
bind76234523bi_nd_
bindi85617023bi_ndi
bindle94516263bi_ndle
binds86627483bi_nds
bird76128333bir_d_
birds85421343bir_ds
birl65830483bir__l
brindle104210103brindle
carnal83919213carnal
cornel84020053cornel
dandle84218093d_andle
dandy104416703d_andy
dared75935013dared_
darn56434623darn__
darned85018483darned
darnels83710433darnels
darner74017303darner
darns66927893darn_s
derail74218813derail
deride84420033deride
dermal93614343dermal
dial55935073di__al
diced95824683diced_
did56850533di__d_
diddle94915213di_ddle
diddly12389573di_ddly
dido66528213di__do
didy99121523di__dy
died66137863di_ed_
diel59034613di__el
diene65720133dien_e
dienes75719903dienes
diesel74410403diesel
diked115024683diked_
dildo71911783di_ldo
dill55239983di__ll
din46459473di_n__
dinar66319893di_nar
dindled104412723di_ndled
dindles93817243di_ndles
dine55555343di_n_e
dined76431993di_ned
diner65632903di_ner
dines66449153di_nes
ding66940963di_n_g
dinge75627303di_nge
dingle84317073di_ngle
dingo74720793di_ngo
dings76331403di_ngs
dingy105721263di_ngy
dink97137813di_n_k
dinkly144311083di_nkly
dinks105927953di_nks
dinky135819373di_nky
dinned84317613dinned
dinner74217163dinner
dino56036763di_n_o
dinos65428063di_nos
dins56652053di_n_s
dint56759063di_n_t
dints67431313di_nts
diobol936883diobol
diode74716123di_ode
diol57329143di__ol
dipnet91317473dipnet
dipody1336363dipody
diram84419473dir_am
dirams94413703dirams
dirdum1036033dirdum
dire56644153dir__e
direct93817333direct
direful1156613direful
direly10311563direly
direr64927073dir_er
direst75024243direst
dirge75117073dir_ge
dirges84915103dirges
dirham12378273dirham
dirk96326843dir__k
dirked124912273dirked
dirks105619523dir_ks
dirled84514903dirled
dirls64720503dir_ls
dirt55550393dir__t
dirtily1138583dirtily
dirts66824463dir_ts
dirty95617803dir_ty
dismal92412243dismal
dispel9310323dispel
distal73615773distal
distil73616433distil
diurnals943803diurnals
dived106321373dived_
divide113410893divide
dorado838813dorado
dorsal74613943dorsal
dorsel75315503dorsel
drail65020973d_rail
drawl95516013d_rawl
dreidl835233dreidl
dried75321383dried_
drill64718263d_rill
drink106816383drin_k
drinks116810713drinks
drivel105110383drivel
droll65415403d_roll
drool65416103d_rool
duende836923duende
dural64923893dur_al
dured75025403dured_
durn56127633durn__
durned84113173durned
durns64819873durn_s
dwindle12415883dwindle
dynel9569853d_ynel
fiend95312983fiend_
fiends104110293fiends
final83922033fi_nal
find87532613fi_nd_
finds95424833fi_nds
fired94829743fired_
firn76927513firn__
firns86018543firn_s
gird65425003gir_d_
girdle82110463gir_dle
girds74817003gir_ds
girl56226563gir__l
girn56026873girn__
girned84010513girned
girns64516803girn_s
grind75917563grind_
grinds84511843grinds
hind85529763hi_nd_
hinds96721483hi_nds
hired95226263hired_
hirsel9138683hirsel
indol63714873_i_ndol
irade65618153_irade
ired55131873_ired_
irid55927183_irid_
irids66417783_irids
kernel104010593kernel
kind96128573ki_nd_
kindle114414243ki_ndle
kindly14358853ki_ndly
kinds106221833ki_nds
kirn87123453kirn__
kirned11408623kirned
kirns95315463kirn_s
lienal63912793lienal
lindy96918323li_ndy
mind75434393mi_nd_
minds85427133mi_nds
mired85729223mired_
pinnal84814283pinnal
pirn67128383pirn__
pirns76020093pirn_s
rind56535613ri_nd_
rinds64826153ri_nds
rindy95717403ri_ndy
signal73711483signal
simnel857023simnel
sired66134283sired_
tarnal63716503tarnal
tirade7311693tirade
tired65228903tired_
tiredly1136803tiredly
tirl45029933tir__l
trinal6516963trinal
trindle83311363trindle
urinal6614123urinal
vernal93514213vernal
viand9511073viand_
viands1047813viands
vinal85725813vi_nal
vinyl115311623vi_nyl
viral86419593vir_al
virid94116043virid_
virl76224483vir__l
wind85533863wi_nd_
windle104617953wi_ndle
winds95425613wi_nds
windy126118113wi_ndy
wired95327643wired_
yird87018993yir_d_
yirds96612523yir_ds

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.393454684.5
2DLD Change Limit1127161965.12322002.0
3Display Results1961960.0633111.1
 (SQL Overall)1786911965.57932029.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.