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

190 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
dirks10561952(None) 
birks114920301birks
darks106727871darks
dicks125824691dicks
dinks105927951dinks
dirk96326831dirk_
dirls64720501dirls
dirts66824461dirts
disks105417471disks
dorks105724441dorks
irks86220131_irks
kirks84915261kirks
mirks115122141mirks
airns55521032airns
airs46447422air_s
airts55626342airts
arks85936872_arks
barks115735812barks
berks115423122berks
bilks115117892bilks
birds85421332birds
birk106326862birk_
birls74023162birls
biros75325132biros
birrs74917102birrs
bisks115416802bisks
borks115727702borks
carks115534212carks
chirks155414842chirks
cires74932912cires
corks116028272corks
daks97130602d_aks
darbs85323262darbs
dares66146702dares
dark95133212dark_
darky136018832darky
darns66927892darns
darts67635732darts
dawks135213492dawks
decks124822192decks
derms85022892derms
desks105913072desks
dhaks13479702dhaks
dials64925342dials
dibs76233682di_bs
dices86434242dices
dick116432382dick_
dicky154816242dicky
didos76820812didos
dies55653522di_es
diets66026642diets
diffs126315482diffs
difs86027322di_fs
digs66036052di_gs
dike95935762di_ke
dikes105831332dikes
dills65530972dills
dimes85833042dimes
dims75435022di_ms
dines66449152dines
dings76331402dings
dink97137802dink_
dinky135819372dinky
dinos65428062dinos
dins56652042di_ns
dints67431312dints
diols65521012diols
dips75536912di_ps
diram84419472diram
dirams94413702dirams
dire56644142dir_e
direr64927072direr
direst75024242direst
dirge75117072dirge
dirges84915102dirges
dirked124912272dirked
dirl57430022dir_l
dirt55550382dir_t
dirty95617802dirty
dis46459892di__s
discs85316262discs
disk96625832disk_
diss56434482di_ss
ditas65923672ditas
dites66339152dites
dits56450522di_ts
divas95418582divas
dives95832402dives
docks126022312docks
dork96531462dork_
dorky135518742dorky
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
dreks105714752dreks
dribs85115062dribs
dries64733672dries
drinks116810712drinks
drips85417232drips
drys86314802d_rys
ducks124823212ducks
dunks105621192dunks
duras65727732duras
dures65635922dures
durns64819862durns
duros65422692duros
durrs65519992durrs
dusks105317252dusks
finks125424222finks
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
forks125324682forks
ginks104319562ginks
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
harks126333432harks
hicks145322172hicks
hires86134342hires
ilks87218572_ilks
inks86926502_inks
ires45639282_ires
iris45732552_iris
irk76426362_irk_
jerks166514892jerks
jinks165019332jinks
kicks104420082kicks
kinks84926082kinks
kirk76221562kirk_
kirns95315452kirns
kirs85831732kir_s
larks95227812larks
licks115325392licks
links96430192links
liras56021982liras
lurks95218742lurks
marks115933482marks
merks114722402merks
micks135525372micks
milks115020582milks
minks115829272minks
mires75640882mires
mirk106729502mirk_
mirky146315522mirky
mirs66940572mir_s
murks114821732murks
narks96026032narks
nicks114920492nicks
oinks94819912oinks
parks116134462parks
perks115325802perks
picks135226142picks
pinks115729382pinks
pirns76020092pirns
porks115124142porks
quirks19419112quirks
ricks115126132ricks
rinks94827102rinks
risks94917062risks
sarks96632462sarks
shirks134814122shirks
sicks115127622sicks
silks94620682silks
sinks95529182sinks
sires55945372sires
sirs44338332sir_s
smirks124910122smirks
stirks104914242stirks
ticks115823292ticks
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turks95320822turks
vires84529682vires
virls85618602virls
virus85316842virus
warks127932402warks
wicks144619362wicks
winks125325432winks
wires86034912wires
works125621902works
yerks125416562yerks
yirds96612512yirds
yirrs8469192yirrs
zerks185113822zerks

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 Filter178691538000.296603685.8
2DLD Change Limit538001901.48636204.6
3Display Results1901900.0464130.4
 (SQL Overall)1786911901.82897752.2
 
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.