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

135 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
antique163888(None) 
antiqued1846541antiqued
antiquer1746871antiquer
antiques1738881antiques
antibug1045152antibug
antifur1047492antifur
antigun847962antigun
antinuke1246492antinuke
antiquate1888032antiquate
antiquely2144222antiquely
antiquers1845792antiquers
unique1558162un_ique
active11313743acti_ve
altitude9166673altitude
anile54634463an_i_le
anime75423203an_i_me
animus84211613an_imus
anise55129703an_i_se
antae56828293ant__ae
ante46538903ant___e
anti45536363anti___
antiabuse1144303antiabuse
antiacne1048583antiacne
antiair7310313antiair
antiar6317173anti_ar
antiars7314623antiars
antibuser1145513antibuser
antic75728863anti__c
anticar9312663anticar
antick124814583anti_ck
anticked1538393anticked
anticks134612253anticks
anticly12410053anticly
antics84621453anti_cs
anticult10411683anticult
antidote949713antidote
antidrug1043833antidrug
antifat10314253antifat
antiflu1046683antiflu
antifog1146313antifog
antigay1148223antigay
antigen8311123antigen
antigene9410203antigene
antijam1648283antijam
antilife11410433antilife
antilog838623antilog
antimale10312463antimale
antiman9313883antiman
antimere10410683antimere
antimine10714753antimine
anting75827023anti_ng
antings85015583antings
antinode9810233antinode
antinome10810443antinome
antinuker1344473antinuker
antinukes1346143antinukes
antiplaque2152373antiplaque
antipode1199283antipode
antipole10910153antipole
antipope1268133antipope
antipot9312923antipot
antiquark2243713antiquark
antiquary2144793antiquary
antiquated2055483antiquated
antiquates1957463antiquates
antiquing1947303antiquing
antiquity2145813antiquity
antirape10410113antirape
antired82316193antired
antirust8411173antirust
antis55033313anti__s
antisag838043antisag
antisex1439693antisex
antismut1047703antismut
antitax1447853antitax
antitype1345463antitype
antiwar1037963antiwar
antiweed1246303antiweed
antlike11312073antlike
antre55224523ant__re
antrum8611313ant_rum
anxious1437283anxious
anytime1246043anyti_me
applique2142583applique
aptitude11195963aptitude
article9310923article
artiste73813693artiste
astilbe945653astilbe
attire62412383atti_re
attitude9196033attitude
auntie64317703aunti__e
bezique2743173bezique
boutique1943283boutique
cacique20205693cacique
caique17318803_caique
canticle1239703canticle
cazique27194033cazique
clique17289193_clique
continue10311123continue
critique1943033critique
detinue85010033detinue
entice81316863enti_ce
entire61617703enti_re
entitle7610293entitle
fatigue1144393fatigue
fique1739143__fique
intimae9109743intimae
intime81014263inti_me
intine61021973inti_ne
intitle7610583intitle
intitule867423intitule
intrigue945233intrigue
lalique1644423lalique
manque17259513man__que
mystique2242393mystique
native9613013nati_ve
oblique1844693oblique
pantie84326473panti__e
pantile93918483panti_le
perique1837523perique
pique16410173__pique
plastique2043043plastique
postique1945873postique
pratique19134283pratique
relique1636823relique
retinue75414843retinue
santimu938553santimu_
silique1645643silique
toque145113093__toque
tuque14469193__tuque
ubique1784883_ubique
uniquer1675783un_iquer
uniques1667443un_iques
untie54425493unti__e
untrue6310773unt_rue

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.1561145455.1
2DLD Change Limit1340271356.81019680.9
3Display Results1351350.0502700.0
 (SQL Overall)1786911357.01625469.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.