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

108 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
anticity1331360(None) 
activity1647582activity
anility10312722an_ility
anticly12410052antic_ly
antiquity2145812antiquity
facticity1945952facticity
nativity1446632nativity
ability12311443a_bility
acidity1338593a_cidity
acridity1446913acridity
affinity1744983affinity
agility1148653a_gility
algidity1345283algidity
alterity1149843alterity
aminity12310513a_minity
analcite1049333analcite
anality10313633an_ality
analyticity1952343analyticity
annuity1045543an_nuity
antacid10311223antaci_d
antacids1148333antacids
antiair7310313antiai_r
antibias10312083antibias
antibody1445343antibody
antic75728863antic___
antically14315683antically
anticar9312663antic_ar
anticipate1467733anticipate
anticivic1645563anticivic
antick124814583antic__k
anticked1538393anticked
anticking1649243anticking
anticks134612253antic_ks
anticline11410703anticline
anticling12310693anticling
anticold1147473anticold
anticrime1346643anticrime
antics84621453antic__s
anticult10411683anticult
anticults1159373anticults
antidote949723antidote
antielite9411603antielite
antifat10314253antifat_
antigay1148223anti_gay
antiking13412073antiking
antilife11410433antilife
antilogy1248103antilogy
antimine10714753antimine
antimony1358303antimony
antinomy1367373antinomy
antiparty1445863antiparty
antipathy1745083antipathy
antipill1046683antipill
antipot9312923antipot_
antiriot8414583antiriot
antiwhite1545533antiwhite
anxiety1744033anxi_ety
aridity11510113a_ridity
atomicity1645513atomicity
atonicity1456223atonicity
atrocity1347213atrocity
atticism1268533atticism
atticist10811343atticist
atticists1167943atticists
atticize1948443atticize
audacity1444823audacity
avidity1436483a_vidity
basicity1546313basicity
caninity1338063can_inity
canonicity1754413canonicity
captivity1944673captivity
causticity1753813causticity
centricity1746043centricity
conicity15411093conicity
cubicity1746033cubicity
elasticity1575383elasticity
enticing11311803enticing
entirety1146063entirety
entity9312053ent__ity
felicity1647913felicity
fetidity1545853fetidity
futility1446973futility
gentility1347063gentility
helicity1648503helicity
infinity1447313infinity
intercity14410003intercity
intracity1448423intracity
inutility1246213inutility
ionicity1348823ionicity
latinity1138813latinity
mendicity1745073mendicity
motility1338733motility
motivity1646223motivity
multicity1647683multicity
natality1139193natality
nicety1138433_n_icety
outcity1238453out_city
plasticity1765603plasticity
rancidity1544313rancidity
rusticity1445963rusticity
septicity1646583septicity
spasticity1754263spasticity
tactility1446833tactility
tonicity1348543tonicity
toxicity2045683toxicity
untidily1245873untidily
utility1038703_utility
vorticity1746143vorticity

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621086.57622226.6
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.02825425.6
 
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.