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

143 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
anticar931266(None) 
antiar6317171anti_ar
antiwar1037961antiwar
antbear935062antbear
antiair7310312antiair
antiars7314622anti_ars
antic75728862antic__
antick124814582antic_k
anticks134612252anticks
anticly12410052anticly
antics84621452antic_s
antifat10314252antifat
antifur1047492antifur
antigay1148222antigay
antijam1648282antijam
antiman9313882antiman
antisag838042antisag
antitax1447852antitax
antiwear1146122antiwear
enticer91510422enticer
acinar8310483a_cinar
actinal9312293actinal
agnatical1246163agnatical
aldicarb1342903aldicarb
altar55520643alt__ar
anear55420323an__ear
angina7413133angina_
anginal8310163anginal
anginas8310953anginas
angular838543angular
anima74620073an_ima_
animal85016253an_imal
animas84418723an_imas
annular737703annular
anta46839583ant__a_
antacid10311223antacid
antae56828293ant__ae
antas55432033ant__as
antbears1044963antbears
anther93715063ant_her
anthrax1757153anthrax
anti45536363anti___
antiacne1048583antiacne
antiarin8413913anti_arin
antibias10312083antibias
antibug1045153antibug
antically14315683antically
anticancer1454893anticancer
anticaries12412473anticaries
antichlor1444883antichlor
anticity13313603anticity
anticked1538393anticked
anticold1147473anticold
anticrack1745433anticrack
anticult10411693anticult
antidora947873antidora
antiflu1046683antiflu
antifoam1347693antifoam
antifog1146313antifog
antigang1067403antigang
antigen8311123antigen
antiglare1046343antiglare
antigun847963antigun
antihero1147673antihero
antilabor1145223antilabor
antileak1247173antileak
antilog838623antilog
antimale10312463antimale
antimask1446573antimask
antimere10410683antimere
anting75827023anti_ng
antings85015583antings
antiparty1445863antiparty
antipolar11106943antipolar
antiporn1048473antiporn
antipot9312923antipot
antiquark2243713antiquark
antiquary2144793antiquary
antique1638883antique
antiquer1746883antiquer
antiradar1045053antiradar
antirape10410113antirape
antired82316193antired
antis55033313anti__s
antisera849193antisera
antisex1439693antisex
antishark1644163antishark
antisolar9116753antisolar
antispam1246033antispam
antistat8413793antistat
antitank1247193antitank
antiulcer1144593antiulcer
antler64615553ant_ler
antra56521923ant_ra_
antral65719413ant_ral
antsier7410773antsier
apical10913903a_pical
arnica8310443arnica_
arnicas939543arnicas
article9310923article
articular1179383articular
artier63419733arti_er
artisan759463artisan
astir55517093asti__r
astylar10265063astylar
attar56516693a_t_tar
attic75618353attic__
attics84413283attic_s
cantic103920543cantic__
canticle1239703canticle
cantina93417253cantina_
cantinas102713783cantinas
entia5318203enti_a_
entice81316863entic_e
enticed101411193enticed
enticers10139093enticers
entices91616333entices
fanatical1446493fanatical
handcar1337373han_dcar
handicap1644933handicap
haptical1547343haptical
indican1048243indican
intima81910033intima_
intimae9109753intimae
intimal9109943intimal
intimas9119583intimas
kantar10311163kant__ar
mantic104120903mantic__
manticore1346083manticore
metical11315363metical
minicar11109323minicar
multicar1247523multicar
nautical1057703nautical
nicad8312613_n_icad
nicer74618293_n_icer
noticer937273noticer
ontic74418573ontic__
optical1149863optical
santir6315253santi__r
tactical1248843tactical
tical76021493__tical
vatical1239983vatical
vicar10513863__vicar

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.420425454.8
2DLD Change Limit1340271437.11018850.5
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.57623586.5
 
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.