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

155 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
ancient951473(None) 
ancients1098971ancients
accent105116262a_ccent
accident13148182accident
ambient11310092ambient
ancienter1145392ancienter
anciently1446142anciently
ancientry1443872ancientry
anent54931842an__ent
anoint6423632anoi_nt
ascent84519652asc_ent
audient8312302audient
fanciest133612712fanciest
incent83320722inc_ent
incident11410202incident
abluent939623abluent
absent84016993a_bsent
accents113511233a_ccents
accept123210623a_ccept
accidents14155133accidents
account11109043account
achene11313813a_chene
achiest12315183achiest
acing87429153a_ci_ng
acini75718983a_ci_ni
advent102613753a_dvent
aeriest73924053aeriest
affiant1348433affiant
agent65829643a__gent
ailment9314233ailment
airiest74221013airiest
alien56425583a_lien_
aliens65619213a_liens
aliment9316703aliment
ambients1246053ambients
ament76036543a__ment
anapest9311553anapest
ancientest1255373ancientest
ancilla948603ancilla
ancon75718233anc_on_
ancone83916953anc_one
ancones93116343ancones
ancress978613ancress
anenst63514983an__enst
angina7413133angi_na
angriest9310253angriest
anion55028813an_ion_
anions64123033an_ions
anklet105618733ankle_t
anoints7311063anoi_nts
anteing8312813anteing
antifat10314253antifat
antigen8311123antigen_
antigene9410203antigene
antigens9310603antigens
antileft1149993antileft
anting75827023anti_ng
antipot9312923antipot
antsiest8511463antsiest
anxiety1744033anxiety
aperient10715153aperient
arcing95819643arci_ng
ardent73022613a_rdent
argent74023663a_rgent
aroint6328153aroi_nt
arpent84822093a_rpent
artiest73121993artiest
ascend9429733asc_end
ascents93812553asc_ents
ashiest10313953ashiest
assent65119953a_ssent
attent62818323a_ttent
audients946353audients
augment10910203augment
candent10417363can_dent
canniest10313363canniest
cent67451013__c_ent
chanciest1638373chanciest
client8316343_client
concent114422513conc_ent
dancing113611563danci_ng
dandiest103415033dandiest
decent94023703dec_ent
diciest103316523diciest
docent92918683doc_ent
enceinte1046263enceinte
enchant12313113enchant
encina8310443enci_na
faciend1334803faciend
fancied133310603fancie_d
fancier123412063fancie_r
fanciers13358083fanciers
fancies124018783fancie_s
handiest123417773handiest
iciest82914743_iciest
incant82418503inc_ant
incents92414533inc_ents
incept102712753inc_ept
incest82918743inc_est
incidents1246803incidents
incipient1347763incipient
incipit1158923incipit
incitant10810083incitant
indent73021243in_dent
indigent102911613indigent
inkiest113415043inkiest
intent63122773in_tent
invent93316363in_vent
laciest93819033laciest
lancet84223573lanc_e_t
lanciers10308543lanciers
lancing103314123lanci_ng
lankiest122912493lankiest
lenient7313843lenient
lucent8313823luc_ent
manchet143317773manche_t
mangiest112815903mangiest
manliest102314943manliest
minciest122913103minciest
nancies93516843nancie_s
nascent9610523nascent
nescient1048713nescient
nicest82315663_nicest
nocent83217413_nocent
occident13126293occident
oncet74626543onc_e_t
orient6322533_orient
paciest112917803paciest
patient9617073patient
pschent1437413pschent
raciest92820013raciest
randiest93418773randiest
rangiest93115983rangiest
recent83630853rec_ent
salient7419763salient
sandiest93218683sandiest
sapient9415333sapient
sauciest10310973sauciest
scent75831623_sc_ent
sentient8313633sentient
tangent8314993tan_gent
tangiest92915223tangiest
transient9713213transient
unbent83216593un_bent
uncini8310153unci_ni
uncleft1257493uncleft
unguent839123unguent
unkent103116053un_kent
unpent83117373un_pent
unrent63219783un_rent
unsent63820963un_sent
unsilent849603unsilent
unspent92610893unspent
waniest103819113wan_iest
zaniest163214773zan_iest

Search took 7 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.1431249587.4
2DLD Change Limit1340271556.45320769.7
3Display Results1551550.0463369.6
 (SQL Overall)1786911556.64226903.2
 
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.