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

145 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
destroy113815(None) 
destroys1236691destroys
bestrow1237242bestrow
descry1256182descr_y
destiny113111462destiny
destroyed1445082destroyed
destroyer1344552destroyer
dextro1436122dextro_
estray95713332_estray
stroy87720392__stroy
vestry1238622vestr_y
astray95615543_astray
bestow1149463best_ow
bestrew1248003bestrew
bestrid1039973bestrid
bestrode1147133bestrode
bestrown1345193bestrown
bestrows1337043bestrows
betray111511443be_tray
bistro8339943bistro_
bistros92810983bistros
cestoi84511953cest_oi
cestos84718093cest_os
cistron9299883cistron
dearly104615323de_arly
deary95826843de_ar_y
deathly14336863deathly
deathy134210233deat_hy
debtor938333debt_or
debtors1038533debtors
decoy115716313de__coy
decry115514353de_cr_y
decury1277963decur_y
defray1337643de_fray
deftly1336533deft_ly
deity94316773deit__y
denary105316863denar_y
dendron947653dendron
deploy1237583de_ploy
deray95024183de__ray
derby114715343de__rby
derry94721373de__rry
desert72725493deser_t
deserts82513053deserts
deserve11108703deserve
desire7415303desir_e
desired9311983desired
desirer8310783desirer
desires81316133desires
desirous947783desirous
desktop1442413desktop
desorb95210203desor_b
desorbs10437713desorbs
desoxy1744623des_oxy
despot93413293des_pot
destain8412083destain
destine83719953destine
destrier9311823destrier
destroyers1443643destroyers
destroying1564903destroying
destruct1148383destruct
desultory1343403desultory
detox13310953de_t_ox
deuteron945993deuteron
dewdrop1442813dewdrop
dextral1577003dextral
dextran1586163dextran
dextrin1587543dextrin
dextrose1645363dextrose
dextrous1646593dextrous
diatron839283diatron
diestrous1046603diestrous
diestrum1145363diestrum
diestrus946523diestrus
distort81120333distort
dogtrot947443dogtrot
dustily113211523dustily
dustrag945363dustrag
dusty96018323dust__y
dystrophy2152533dystrophy
entropy1247353_entropy
entry82414263_entr_y
escrow1135913_escrow
estop74312103_est_op
estral64716513_estral
estrays10529403_estrays
estrin6315923_estrin
estriol747553_estriol
estrone7413953_estrone
estrous7712533_estrous
estrum81810513_estrum
estrus61912113_estrus
festoon1037673festoon
gentry103410443gentr_y
herstory1446693herstory
history1339423history
kestrel1137113kestrel
maestro945723maestro_
maestros1046163maestros
mesotron1045383mesotron
metro74718803me_tro_
metros84217803me_tros
nestor63713423nest_or
nestors73614973nestors
neutron737763neutron
oestrin7312243oestrin
oestriol845383oestriol
oestrone849973oestrone
oestrous869923oestrous
oestrum9177783oestrum
oestrus7169583oestrus
pastry114913033pastr_y
peltry11288653peltr_y
pesto75723723pest_o_
pestos84719083pest_os
pesty106421713pest__y
petrol82714063pe_trol
postboy1476673postboy
rectory123512733rectory
respray1236503respray
restore75822983restore
restroom1047573restroom
restrove1138963restrove
restudy1144763restudy
retro55020953re_tro_
retros63820193re_tros
retry84718083re_tr_y
sentry92912053sentr_y
story86723033__story
stray88525573__stray
strop77422243__strop
strow88920573__strow
stroys95914603__stroys
testacy1235963testacy
testify13246943testify
testily102910803testily
teston6313303test_on
testoon748373testoon
testy85419063test__y
troy77429683___troy
vestral104111013vestral
wastry12388773wastr_y
westerly1445553westerly
zestily19167563zestily
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 Limit1340271456.33021173.3
3Display Results1451450.0463152.2
 (SQL Overall)1786911456.77926359.5
 
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.