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

164 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
testify1324694(None) 
testily102910801testily
beatify1536592beatify
certify1546242certify
destiny113111462destiny
justify2034662justify
mystify1843562mystify
rectify1536452rectify
retestify1543752retestify
tastily103311642tastily
terrify1336352terrify
testacy1235962testacy
testier74015642testier
testing86021052testing
testis64916712testi_s
testy85419062test__y
zestily19167562zestily
acetify1545003acetify
aerify122810113ae_rify
basify1437513bas_ify
beautify1643183beautify
bestial9311643bestial
bestiary1344813bestiary
besting104923923besting
bestir8311163besti_r
bestirs9311133bestirs
brutify1543883brutify
cesti75217423cesti__
chestily1645523chestily
citify1437443_citify
deify124112763de__ify
demystify2151403demystify
densify1435293densify
desertify1643643desertify
destine83719953destine
destroy1138153destroy
dustily113211523dustily
edify12308563_e_dify
entity9312053_entity
esterify1445623_esterify
estray95713333_estray
feistily1445263feistily
festive1339773festive
fortify1636523fortify
fustily133111373fustily
gasify1336333gas_ify
gentrify1544683gentrify
gestic9312773gesti_c
gratify1436113gratify
gustily113010903gustily
hastily133010663hastily
heftily1635763heftily
identify1544133identify
jellify2054543jellify
jesting154317713jesting
lustily103611243lustily
mastiff1538163mastiff
meatily12311093meatily
messily12298813messily
mestino9411643mestino
mestiza1835383mestiza
mestizo1845943mestizo
metrify1535623metrify
mistily122612343mistily
mortify1536223mortify
mustily123613633mustily
nastily103011033nastily
nesting84320443nesting
notify1236943_notify
ossify1244973_ossify
peskily1635083peskily
pestier94317403pestier
pesty106421713pest__y
petrify1536573petrify
pettily1238173pettily
prettify1644343prettify
ratify122610043_ratify
reedify1465763reedify
reify114814973re__ify
rejustify2242083rejustify
renotify1454833renotify
resift94017723res_ift
resinify1445053resinify
resiny94617363res_iny
restaff1339013restaff
resting85031183resting
restive10315933restive
restudy1144763restudy
restuff1346953restuff
reunify1344453reunify
russify1334063russify
rustily103112993rustily
sestina72711973sestina
sestine73017923sestine
stellify1443883stellify
stiff114219243__stiff
stimy105114743__stimy
stratify1445703stratify
stultify1442723stultify
tackify1934493tackify
tantivy1335563tantivy
tartily103511573tartily
tastier711817093tastier
tasting84624213tasting
tasty84820313tast__y
tattily10409993tattily
tearily10311153tearily
teatime9310083teatime
techily1537123techily
tectite9310583tectite
tektite1136883tektite
tensity1039103tensity
tenthly1335743tenthly
tentie62521183tenti_e
tentier73815923tentier
tenting84621153tenting
tenty86121603tent__y
tenuity1037453tenuity
tepefy1434803te_pefy
tertial7313863tertial
tertian7511193tertian
tertiary1145433tertiary
test48651623test___
testa54822043test__a
testae64216253test_ae
testate73916233testate
tested74421523test_ed
testee64323303test_ee
testees74215913testees
tester64227153test_er
testers74124543testers
testes65125823test_es
testicle1037443testicle
testiest82715223testiest
testified1397843testified
testifier12116893testifier
testifies12139263testifies
testifying1745403testifying
testimony1442313testimony
teston6313303test_on
testons7313563testons
testoon748373testoon
tests56530193test__s
testudo843363testudo
tetany959843te_tany
tetchy1436003te_tchy
textile1437223textile
torrify1335013torrify
trustily11257103trustily
tuftily1335573tuftily
typify1734523t_ypify
vastity1336203vastity
verbify1834993verbify
verify153110163ve_rify
versify1636333versify
vestiary1444313vestiary
vestige1137433vestige
vesting114618683vesting
vestry1238623vest_ry
westing115020273westing
yeastily1444573yeastily
zestier163010223zestier
zesting174515333zesting
zesty176512163zest__y

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.403443402.0
2DLD Change Limit1340271646.29621287.6
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.76226425.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.