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

208 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
mirks11512214(None) 
birks114920301birks
dirks105619521dirks
irks86220131_irks
kirks84915271kirks
marks115933481marks
merks114722401merks
micks135525371micks
milks115020581milks
minks115829271minks
mires75640881mires
mirk106729511mirk_
mirky146315521mirky
mirs66940581mir_s
murks114821731murks
smirks124910121smirks
airns55521032airns
airs46447432air_s
airts55626342airts
amirs75924922amir_s
arks85936872_arks
barks115735812barks
berks115423122berks
bilks115117892bilks
birds85421342birds
birk106326872birk_
birls74023162birls
biros75325132biros
birrs74917102birrs
bisks115416802bisks
borks115727702borks
carks115534212carks
chirks155414842chirks
cires74932912cires
corks116028272corks
darks106727872darks
dicks125824692dicks
dinks105927952dinks
dirk96326842dirk_
dirls64720502dirls
dirts66824462dirts
disks105417472disks
dorks105724442dorks
emirs76116162emir_s
finks125424222finks
fires85740752fires
firms105217422firms
firns86018542firns
firs76637722fir_s
forks125324682forks
ginks104319562ginks
girds74817002girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
harks126333432harks
hicks145322172hicks
hires86134342hires
ilks87218572_ilks
inks86926502_inks
ires45639282_ires
iris45732552_iris
irk76426372_irk_
jerks166514892jerks
jinks165019332jinks
kicks104420092kicks
kinks84926092kinks
kirk76221582kirk_
kirns95315462kirns
kirs85831752kir_s
larks95227812larks
licks115325392licks
links96430192links
liras56021982liras
lurks95218742lurks
macks135127602macks
mairs76228302mair_s
maras75443302maras
marcs95726622marcs
mares76457632mares
mark105138062mark_
marka114620802marka
markas124717012markas
marls75535162marls
mars66261872mar_s
marts77442232marts
masks115320532masks
mbiras1077152mbiras
mercs96020452mercs
meres75143572meres
merk106027942merk_
merls77423902merls
mibs85330492mi_bs
micas96823052micas
mick126333442mick_
micros104115362micros
mics87435162mi_cs
midis85923422midis
mids76541802mi_ds
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935332mi_gs
mike105535302mi_ke
mikes115129892mikes
mikra114610312mikra
milds86422062milds
miles74645072miles
milk105028482milk_
milky144014442milky
mills75435052mills
milos75428012milos
mils66045342mi_ls
milts75430712milts
mimes95732022mimes
minas75434112minas
minds85427132minds
mines75651952mines
minis75432992minis
mink106636542mink_
minke115421762minke
minkes124618782minkes
mints76834042mints
minus75223932minus
mips85534092mi_ps
mir57046782mir__
mire66748242mir_e
mired85729222mired
mirex146816622mirex
miri66730382mir_i
mirin75023152mirin
mirins83918902mirins
mirker123712692mirker
mirkest13309722mirkest
mirth106418892mirth
mirths114912992mirths
miry96326762mir_y
mirza16410442mirza
mirzas1738182mirzas
mis58162632mi__s
mises74740562mises
misos76523292misos
miss65339432mi_ss
mists76633902mists
mites75141802mites
mitis75425992mitis
mitres83922072mitres
mitts75523752mitts
mixes147224402mixes
mocks135023822mocks
moires8915632moires
monks116123392monks
moras76438782moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
mosks116117002mosks
mucks134622642mucks
muras75329582muras
mures75937222mures
murk105527252murk_
murky145216682murky
murrs75521302murrs
musks116119642musks
narks96026032narks
nicks114920492nicks
oinks94819912oinks
parks116134462parks
perks115325802perks
picks135226142picks
pinks115729382pinks
pirns76020092pirns
porks115124142porks
quirks19419112quirks
ricks115126132ricks
rinks94827102rinks
risks94917062risks
sarks96632462sarks
shirks134814122shirks
sicks115127622sicks
silks94620682silks
sinks95529182sinks
sires55945372sires
sirs44338342sir_s
smerks12449712smerks
smirk116612752smirk_
smirky15406942smirky
stirks104914242stirks
ticks115823292ticks
tires55437492tires
tirls54519802tirls
tiros54524892tiros
turks95320822turks
umiaks1244952umiaks
vires84529682vires
virls85618602virls
virus85316842virus
warks127932402warks
wicks144619362wicks
winks125325432winks
wires86034912wires
works125621902works
yerks125416562yerks
yirds96612522yirds
yirrs8469192yirrs
zerks185113822zerks

Search took 3 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.313570897.8
2DLD Change Limit538002081.68631909.8
3Display Results2082080.0633301.6
 (SQL Overall)1786912082.06286659.1
 
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.