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

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
anticly1241005(None) 
antic75728862antic__
antically14315682antically
anticar9312662anticar
anticity13313602anticity
antick124814582antic_k
anticks134612252anticks
anticold1147472anticold
antics84621452antic_s
anticult10411692anticult
antiflu1046682antiflu
antigay1148222antigay
article9310922article
artily92814712arti_ly
canticle1239702canticle
franticly1744012franticly
acidly125211793a_cidly
acridly13396533acridly
actively1647063actively
actorly1246423actorly
aerily93017013aeri_ly
airily93014823airi_ly
anally9513503an_ally
anarchy1544933anarchy
ancilla948603ancilla
angerly1137773angerly
angrily1137723angrily
anil46437433an_i_l_
anile54634463an_i_le
anils56326723an_i_ls
anomaly1238843anomaly
antacid10311223antacid
anthill1048203anthill
anthills1146533anthills
anti45536363anti___
antiacne1048583antiacne
antiair7310313antiair
antiar6317173anti_ar
antiars7314623antiars
antibody1445343antibody
antibug1045153antibug
antichlor1444883antichlor
anticked1538393anticked
anticline11410703anticline
anticling12310693anticling
anticults1159383anticults
antifat10314253antifat
antifog1146313antifog
antifur1047493antifur
antigen8311123antigen
antigun847963antigun
antijam1648283antijam
antilog838623antilog
antilogy1248103antilogy
antimale10312463antimale
antiman9313883antiman
antimony1358303antimony
anting75827023anti_ng
antings85015583antings
antinomy1367373antinomy
antipill1046683antipill
antipole10910153antipole
antipot9312923antipot
antique1638883antique
antiquely2144233antiquely
antired82316193antired
antiroll847763antiroll
antis55033313anti__s
antisag838043antisag
antisex1439693antisex
antislip1046323antislip
antitax1447853antitax
antiwar1037963antiwar
antral65719413antral_
antsy85712793ant__sy
anvil82712603anvi_l_
anvils9219713anvi_ls
anxiety1744033anxiety
aptly105111813apt__ly
aridly105513703a_ridly
articled1137063articled
articles10310253articles
atilt54828473a_ti_lt
attic75618353attic__
attics84413283attic_s
audibly13216043audibly
auntly95211063aunt__ly
auricle9139813auricle
avidly13548783a_vidly
candidly1545213candidly
cannily1239263canni_ly
cantic103920543cantic__
canticles1339183canticles
cattily123210853catti_ly
chicly16429203_chicly
cubicly1644993cubicly
cuticle1138233cuticle
daintily1245523dainti_ly
dandily12279633dandi_ly
denticle1137773denticle
entice81316863entic_e
enticed101411193enticed
enticer91510423enticer
entices91616333entices
entirely1147333entirely
entitle7610293entitle
entity9312053enti_ty
fancily1538253fanci_ly
fattily13379463fatti_ly
fetidly1435013fetidly
handily143610873handi_ly
hastily133010663hasti_ly
hecticly1843003hecticly
intactly1344743intactly
intitle7610583intitle
jauntily1834173jaunti_ly
lankily1437123lanki_ly
mangily1339753mangi_ly
manlily1238743manli_ly
mantic104120903mantic__
mantilla1048163mantilla
mysticly1843323mysticly
nastily103011033nasti_ly
natively1446413natively
nattily103610323nattily
nicely1139493_n_icely
noily86120993_noi_ly
ontic74418573ontic__
ontically14311843ontically
panicky1833853pan_icky
panicle11129983pan_icle
pantile93918483panti_le
pantingly1537863pantingly
particle1239543particle
plasticly1644763plasticly
rancidly1444433rancidly
rantingly1337933rantingly
reticle94112623reticle
rusticly1345183rusticly
saltily10310543salti_ly
sanicle91210263san_icle
scantily1337583scanti_ly
shticky19344473shticky
sticky154711343_sticky
stilly93714093_stilly
tangibly1444673tangibly
tantivy1335563tanti_vy
tartily103511573tarti_ly
tastily103311643tasti_ly
tattily10409993tatti_ly
unchicly1843883unchicly
unfitly1335573unfitly
untidily1245873untidily
untidy1059153unti_dy
until53517743unti_l_
untimely1346903untimely
untruly1046293untruly
wantonly1443063wantonly
zanily18310183zan_i_ly

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.406440125.6
2DLD Change Limit1340271597.19018640.8
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.65623340.0
 
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.