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

110 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
testacy123596(None) 
eustacy1254662eustacy
intestacy1444132intestacy
restack1339432restack
testa54822042testa__
testae64216252testa_e
testate73916232testate
testify13246942testify
testily102910802testily
testy85419062test__y
tetany959842te_tany
apostacy1544283apostacy
bestiary1344813bestiary
cesta75419483cesta__
cestas85018543cesta_s
destain8412083destain
destiny113111463destiny
destroy1138153destroy
detach12310413de_tach
ecstasy1252603ecstasy
essay867623_essa_y
estate64719763_estate
estray95713333_estray
estuary1034683_estuary
eustasy1043873eustasy
eutaxy1643303_eutaxy
festal94213563festa_l
festally1437543festally
gestalt8411173gestalt
gestapo1044493gestapo
gestate83614073gestate
gestic9312773gestic_
hesitancy1743543hesitancy
instancy1346573instancy
isostacy1343023isostacy
legacy1256653le_gacy
mediacy1536143mediacy
nectary1246223nectary
pessary1246873pessary
pesty106421713pest__y
resay85320543res_a_y
respace11310913respace
restacks1438093restacks
restaff1339013restaff
restage83316193restage
restamp1146483restamp
restart7320033restart
restate73824883restate
restock1338673restock
restudy1144763restudy
retack122612823re_tack
sectary1238273sectary
spacy125415623__spacy
stack114421693__stack
stagy96618893__stagy
stay78333723__sta_y
tastily103311643tastily
tasty84820313tast__y
teach105221123te__ach
teary85124053te__ary
tecta74215523tecta__
tectal83713253tecta_l
tenace82715693te_nace
tenancy1237503tenancy
tentacle1037693tentacle
tentage81010643tentage
tenthly1335743tenthly
tenty86121603tent__y
ternary1038343ternary
terrace93311843terrace
tertiary1145433tertiary
tesla55612603tesla__
teslas64212173tesla_s
test48651623test___
testable101412623testable
testacean1142363testacean
testacies1148373testacies
testates83615453testates
testator847373testator
tested74421523test_ed
testee64323303test_ee
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testicle1037443testicle
testier74015643testier
testing86021053testing
testis64916713test_is
teston6313303test_on
testons7313563testons
testoon748373testoon
tests56530193test__s
testudo843363testudo
tetchy1436003te_tchy
textuary1842673textuary
tictac1036563tictac_
tictacs1145793tictacs
tostada894953tostada
tostado895953tostado
unstack1337373unstack
vesta86618303vesta__
vestal94615573vesta_l
vestally1437413vestally
vestals104612333vestals
vestas95916683vesta_s
vestiary1444313vestiary
vestry1238623vest_ry
zestily19167563zestily
zesty176512163zest__y

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.403443402.0
2DLD Change Limit1340271106.83019623.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.27924548.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.