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

126 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
antis5503331(None) 
anis45746461an_is
antas55432031antas
antes56334321antes
anti45536361anti_
antic75728861antic
antics84621451antics
ants47243471ant_s
intis55121641intis
mantis83926031mantis
abatis84317932abatis
abris75722602abris
actin74922552actin
actins86321102actins
acts66929862act_s
adits66523712adits
aegis6316782aegis
ahis76135382a_his
ais39083572a__is
aits46355532ait_s
altos55822952altos
alts46639902alt_s
amis66445322a_mis
anas46649862an_as
ands57833612an_ds
anes45255932an_es
angas65827982angas
ani37751182an_i_
anil46437432an_il
anils56326722anils
animis84615942animis
anise55129702an_ise
ankhs12116722ankhs
ankus91410682ankus
anlas55626932anlas
annas55824882annas
anoas57226492anoas
ant37270792ant__
anta46839582ant_a
antae56828292antae
ante46538902ant_e
anted66328242anted
antiar6317172antiar
antiars7314622antiars
antick124814582antick
anticks134612252anticks
anting75827022anting
antings85015582antings
antisag838042antisag
antisex1439692antisex
antra56521922antra
antre55224522antre
antres65021002antres
antsy85712792antsy
anus47131112an_us
anvil82712602anvil
anvils9219712anvils
aphis105917132aphis
apsis75718292apsis
arris56824682arris
arsis55722422arsis
artist64125542artist
arts49650262art_s
aspis74618142aspis
astir55517092astir
ates45047922a_tes
attic75618352attic
attics84413282attics
auntie64317702auntie
aunties73920072aunties
aunts55227632aunt_s
auris55331532auris
autism83815332autism
autist64324942autist
autos56523322autos
axis116127912a_xis
banties94324762banties
cantic103920542cantic
cantos84826972cantos
cants77036942cant_s
cantus85117762cantus
cutis77723762cutis
entia5318202entia
hants86335402hant_s
inti46626082inti_
kanjis1735962kanjis
knits93914742knits
lanais6316792lanais
mantas85725362mantas
mantes84430782mantes
mantic104120902mantic
mantid93820382mantid
mantids103113622mantids
metis75025902metis
mitis75425992mitis
nabis76020582nabis
naris55735292naris
nates55238332nates
nazis145216082nazis
nits45741642_nits
ontic74418572ontic
pantie84326472pantie
panties94230932panties
pantos85222742pantos
pants76536922pant_s
pastis84924322pastis
ranis55235832ran_is
rants55935342rant_s
rotis56327062rotis
santims9312602santims
santir6315252santir
santirs7312962santirs
santos64421832santos
satis55633682satis
shantis103313102shantis
snits54124832snits
tis37056642__tis
titis56023812titis
unais53420772unais
units54923432units
untie54425492untie
unties64326922unties
until53517742until
wants87932212want_s
yetis85418392yetis
zitis145815582zitis

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.0931921408.6
2DLD Change Limit538001261.53035163.4
3Display Results1261260.0333818.2
 (SQL Overall)1786911261.656107905.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.