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 “testacies” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
testacies114837(None) 
eustacies1146602eustacies
intestacies1355302intestacies
tentacles1146712tentacles
testates83615452testa_tes
testicles1146772testicles
testifies12139262testifies
tetanies8513552te_tanies
apostacies1445603apostacies
bestiaries1245973bestiaries
destains9311813desta_ins
destinies10410843destinies
detaches1439653de_taches
ecstasies1145043ecstasies
estancias1145003_estancias
estates74520183_esta_tes
estuaries946213_estuaries
eustasies946023eustasies
eutaxies1545793_eutaxies
gestates93213733gesta_tes
hesitancies1643993hesitancies
instancies1246613instancies
isostacies1244433isostacies
legacies1139043le_gacies
mediacies1447183mediacies
mustaches16166053mustaches
nectaries1149813nectaries
obstacles1343713obstacles
pentacles1338773pentacles
pessaries11108663pessaries
pesticides1546723pesticides
pistaches1646673pistaches
respaces12311043respac_es
restables111511423restables
restacked1636483restacked
restacks1438093restac_ks
restages92815773resta_ges
restates83423433resta_tes
restudies10156033restudies
sectaries11312243sectaries
stactes91914633__stactes
teaches122718353te__aches
tectrices1346253tectrices
tenaces92814513te_nac_es
tenancies1149173tenancies
tentacle1037693tentacle_
tentacled1244953tentacled
tentages91011043tenta_ges
tentatives1345483tentatives
ternaries9311643ternaries
terraces102712253terrac_es
tertiaries1047003tertiaries
testable101412623testable_
testacean1142363testacean
testaceans1251913testaceans
testaceous1253313testaceous
testacy1235963testac__y
testae64216253testa__e_
testate73916233testa_te_
testators947333testators
testatrices1352803testatrices
testatrixes1852093testatrixes
testees74215913test__ees
testes65125823test___es
testicle1037443testicle_
testier74015643test__ier
testiest82715223test__iest
testified1397843testified
testifier12116893testifier
testifiers13124503testifiers
testis64916713test__i_s
testudines1143093testudines
tetanics10127373te_tanics
tetanise8610203te_tanise
tetanises979873te_tanises
tetanizes1889843te_tanizes
tetracids1245933tetracids
textuaries1743623textuaries
vestiaries1345373vestiaries
vestries11314053vest_ries

Search took 9 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 Filter1786911486410.420425454.8
2DLD Change Limit148641807.59319576.1
3Display Results80800.0332424.2
 (SQL Overall)178691808.04622208.7
 
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.