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

118 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
antiques173888(None) 
antique1638881antique_
antiqued1846541antiqued
antiquer1746871antiquer
antiquers1845791antiquers
antinukes1346142antinukes
antiquates1957462antiquates
antiquely2144222antiquely
uniques1667442un_iques
actives12311523acti_ves
altitudes10196583altitudes
animes84719593an_i_mes
animus84211613an_imu_s
animuses1037983an_imuses
anises64826693an_i_ses
antes56334323ant___es
antheses11311473antheses
antiabuse1144303antiabuse
antiars7314623anti_ars
antibias10312083antibias
antiboss1047273antiboss
antibug1045153antibu_g
antibuser1145513antibuser
antibusers1244423antibusers
anticked1538393anticked
anticks134612253anti_cks
antics84621453anti__cs
anticult10411683anticult
anticults1159373anticults
antidotes1049533antidotes
antifur1047493antifu_r
antigen8311123anti_gen
antigenes10411433antigenes
antigens9310603antigens
antigun847963antigu_n
antilogs949603antilogs
antimeres11410893antimeres
antings85015583anti_ngs
antinodes1099603antinodes
antinomes11710143antinomes
antinuke1246493antinuke
antinuker1344473antinuker
antinukers1443873antinukers
antipodes1278923antipodes
antipoles11810473antipoles
antipopes1368613antipopes
antipress1146413antipress
antiquaries2056323antiquaries
antiquark2243713antiquark
antiquarks2353083antiquarks
antiquary2144793antiquary
antiquate1888033antiquate
antiquated2055483antiquated
antiquing1947303antiquing
antiquities2056623antiquities
antiquity2145813antiquity
antired82316193anti_red
antirust8411173antirust
antirusts948143antirusts
antis55033313anti___s
antisex1439693anti_sex
antitypes1445543antitypes
antiweed1246303antiweed
antres65021003ant__res
antrums969173ant_rums
anxious1437283anxiou_s
appliques2242553appliques
aptitudes12156183aptitudes
articles10310243articles
artistes83213343artistes
astilbes1044733astilbes
attires72312953atti_res
attitudes10155743attitudes
aunties73920073aunti__es
banties94324763banti__es
beziques2843213beziques
boutiques2043193boutiques
caciques21165373caciques
caiques18248793_caiques
canticles1339183canticles
caziques28193773caziques
cliques18309203_cliques
continues11310993continues
critiques2042593critiques
detinues9569823detinues
entices91616333enti_ces
entires71517783enti_res
entities8617413entities
entitles8710663entitles
fatigues1244193fatigues
fiques1837973__fiques
intines7921113inti_nes
intitles8710003intitles
intitules966773intitules
intrigues1045363intrigues
laliques1744833laliques
mantises10317923manti_ses
mystiques2342423mystiques
natives10310823nati_ves
obliques1944513obliques
panties94230933panti__es
pantiles103617153panti_les
periques1937653periques
piques1739093__piques
plastiques2142813plastiques
postiques2045833postiques
pratiques20114213pratiques
reliques1736903reliques
retinues85113153retinues
siliques1745353siliques
tantivies1247103tantivies
toques154612353__toques
tuques15358373__tuques
unique1558163un_ique_
uniquer1675783un_iquer
uniquest1775603un_iquest
untidies939813untidies
unties64326923unti__es

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.420425454.8
2DLD Change Limit1461621187.01620832.7
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.48223882.8
 
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.