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

130 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
dirndls93389(None) 
dirndl834251dirndl_
darnels83710432darnels
dindle84417222di_ndle
dindles93817242di_ndles
dirls64720502dir__ls
diurnals943802diurnals
airns55521033airn__s
bindis94614583bi_ndis
bindle94516263bi_ndle
bindles104016453bi_ndles
binds86627473bi_nd_s
birds85421333bir_d_s
birls74023163bir__ls
brindle104210103brindle
brindles113710223brindles
cornels94716663cornels
dandle84218093d_andle
dandles94218533d_andles
darndest1067223darndest
darnel74312183darnel_
darners83815773darners
darns66927893darn__s
derails84216393derails
derides93420853derides
dials64925343di__als
diddle94915213di_ddle
diddles103915073di_ddles
diddly12389573di_ddly
didos76820813di__dos
dienes75719903dien_es
diesels8429143diesels
dildos8179303di_ldos
dills65530973di__lls
dimness1038843dimness
dinars75417563di_nars
dindled104412723di_ndled
diners75525953di_ners
dines66449153di_n_es
dinges83825423di_nges
dingle84317073di_ngle
dingles93818323di_ngles
dings76331403di_n_gs
dingus83611843di_ngus
dinkly144311083di_nkly
dinks105927953di_n_ks
dinners83915443dinners
dinos65428063di_n_os
dins56652043di_n__s
dints67431313di_n_ts
diobols1036543diobols
diodes83915783di_odes
diols65521013di__ols
dipnets10109033dipnets
dirams94413703dir_ams
dirdum1036033dir_dum
dirdums1134383dirdums
directs102710263directs
direly10311563dir_ely
direness9311303direness
dirges84915103dir_ges
dirhams13376313dirhams
dirks105619523dir__ks
dirl57430023dir__l_
dirties83119383dirties
dirtily1138583dirtily
dirts66824463dir__ts
dismals102010243dismals
dispels10310503dispels
distils83015803distils
diurnal844883diurnal_
divides123211453divides
dorados938203dorados
dorsals84110843dorsals
dorsels84412573dorsels
drails74716953d_rails
drawls105511393d_rawls
dreidls934053dreidls
drills74414203d_rills
drinks116810713drin_ks
drivels11397923drivels
drolls75312393d_rolls
drools74412813d_rools
duendes938193duendes
durndest1065763durndest
durns64819873durn__s
dwindle12415883dwindle
dwindles13366023dwindles
dynels10536813d_ynels
fiends104110293fiend_s
finals94316163fi_nals
finds95424823fi_nd_s
firns86018543firn__s
girdle82110463gir_dle
girdles92210003gir_dles
girds74816993gir_d_s
girls64518393gir__ls
girns64516803girn__s
grinds84511843grind_s
hinds96721473hi_nd_s
hirsels10128343hirsels
indols74714203_i_ndols
irades74517393_irades
irides74519123_irides
irids66417773_irid_s
kernels11417953kernels
kindle114414233ki_ndle
kindles123614843ki_ndles
kindly14358843ki_ndly
kinds106221823ki_nd_s
kirns95315453kirn__s
minds85427123mi_nd_s
pirns76020093pirn__s
rinds64826143ri_nd_s
signals8359163signals
simnels976103simnels
tirades8311723tirades
tiredly1136803tiredly
tirls54519803tir__ls
trindle83311363trindle
trindles93211683trindles
urinals7610263urinals
viands1047813viand_s
vinals94716483vi_nals
vinyls12467003vi_nyls
virls85618603vir__ls
windle104617953wi_ndle
windles113518493wi_ndles
winds95425603wi_nd_s
yirds96612513yir_d_s

Search took 8 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.403443402.0
2DLD Change Limit1340271307.26618445.8
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.71523161.5
 
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.