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

159 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
micas9682305(None) 
mica86428251mica_
micks135525371micks
mics87435151mic_s
minas75434111minas
picas94626521picas
amias75831472ami_as
amices105018012amices
amicus103810002amicus
amigas95912172amigas
bias64738162bi_as
bices95029962bices
bimas95521742bimas
cacas95627982cacas
chicas135916472chicas
cocas95926572cocas
cycas126513822cycas
dicast9315572dicast
dices86434242dices
dicks125824692dicks
ditas65923672ditas
divas95418582divas
ericas8315462ericas
fices106031162fices
ficus105015492ficus
fincas113512072fincas
gigas75415582gigas
hicks145322172hicks
ices66129642_ices
ichs96214712_ichs
kicks104420082kicks
kinas95626912kinas
kivas124614732kivas
licks115325392licks
limas75627632limas
liras56021982liras
litas54923772litas
macaw12311762macaw
macaws1337022macaws
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512mac_s
mamas95930772mamas
manas76240432manas
maras75443292maras
mas58175822m__as
masas75630412masas
mayas105924382mayas
mbiras1077152mbiras
meccas1239492meccas
mesas76823202mesas
miasm91211092mi_asm
mibs85330482mi_bs
mic77647642mic__
mice87442232mic_e
miche126219242miche
miches134320732miches
mick126333432mic_k
micra96214972micra
micro94715992micro
micros104115362micros
midcap1336472midcap
midis85923412midis
mids76541792mi_ds
miens76118302miens
miffs134512882miffs
miggs96311372miggs
migs76935322mi_gs
mikes115129892mikes
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
milpas101710272milpas
mils66045332mi_ls
milts75430712milts
mimes95732022mimes
mina65136922mina_
minae75627722minae
minces104420802minces
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
mips85534082mi_ps
mires75640882mires
mirks115122142mirks
mirs66940572mi_rs
mirzas1738182mirzas
mis58162622mi__s
miscast11312422miscast
mises74740562mises
misos76523292misos
miss65339422mi_ss
mists76633902mists
mites75141802mites
mitis75425992mitis
mitts75523752mitts
mixes147224402mixes
moas65545342m_oas
mochas13310662mochas
mocks135023822mocks
mocs85834902moc_s
molas75132092molas
monas74732152monas
moras76438782moras
moxas145014402moxas
mucks134622642mucks
mucus94015742mucus
muras75329582muras
mycs115314292myc_s
mynas105815232mynas
myricas1436752myricas
nicad8312612nicad
nicads938332nicads
nicks114920492nicks
nipas77116672nipas
ocas66729632_ocas
orcas75918622orcas
pacas96029402pacas
pias66542552pi_as
pica85831492pica_
pical95524372pical
picks135226142picks
pics85633912pic_s
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pitas77427672pitas
rias45540592ri_as
rices75536152rices
ricks115126132ricks
sices75637272sices
sicks115127622sicks
sics65234092sic_s
sikas94617022sikas
simas75727552simas
socas74026182socas
spicas104715822spicas
tical76021492tical
ticals83214712ticals
ticks115823292ticks
tics65729632tic_s
umiacs1035662umiacs
vicar10513862vicar
vicars11712262vicars
vices105725532vices
vigas94817882vigas
vinas85126342vinas
vincas113912452vincas
visas84317652visas
vivas114815022vivas
wiccas1336542wiccas
wicks144619362wicks
yucas106013912yucas

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 Limit538001591.59633709.3
3Display Results1591590.0463456.5
 (SQL Overall)1786911591.93892203.8
 
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.