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

107 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
destroys123669(None) 
destroy1138151destroy_
bestrows1337042bestrows
desirous947782desirous
destroyed1445082destroyed
destroyer1344552destroyer
destroyers1443642destroyers
dextrous1646592dextrous
diestrous1046602diestrous
estrays10529402_estrays
estrous7712532_estrous
oestrous869912oestrous
stroys95914602__stroys
anestrous946593anestrous
bestows1248863best_ows
bestrews1335603bestrews
bestrode1147133bestrode
bestrow1237243bestro_w
bestrown1345193bestrown
betrays12127823be_trays
bistros92810983bistro_s
cestos84718093cest_o_s
cistrons102710623cistrons
debtors1038533debt_ors
decorous1138853decorous
decoys123911283de__coys
defrays1436113de_frays
dendrons1047393dendrons
deploys1336523de_ploys
derays105514253de__rays
descries11311923descries
descry1256183descr_y_
deserts82513053deser_ts
deserves12109893deserves
desirers939263desirers
desires81316133desir_es
desktops1542463desktops
desorbs10437713desor_bs
despots10319683des_pots
destains9311813destains
destines93619663destines
destiny113111463destiny_
destrier9311823destrier
destriers1038143destriers
destroying1564903destroying
destruct1148383destruct
destructs1245773destructs
deuterons1046783deuterons
dewdrops1542963dewdrops
dexterous1745553dexterous
dextrans1695983dextrans
dextrins16117823dextrins
dextro1436123dextro__
dextrorse1742353dextrorse
dextrose1645363dextrose
dextroses1745663dextroses
diatrons939613diatrons
diestrums1244413diestrums
diestrus946523diestr_us
distorts91112343distorts
distress9311703distress
dogtrots1044693dogtrots
dustrags1044943dustrags
escrows1235803_escrows
estops84011223_est_ops
estray95713333_estray_
estrins7315853_estrins
estriols856253_estriols
estrone7413953_estrone
estrones8313323_estrones
estrums9208603_estrums
estrus61912113_estr_us
festoons1136433festoons
kestrels1235813kestrels
lustrous877803lustrous
maestros1046163maestro_s
mesotrons1145513mesotrons
metros84217803me_tro_s
nestors73614953nest_ors
neutrons838293neutrons
oestrins8312673oestrins
oestriols944333oestriols
oestrone849973oestrone
oestrones949773oestrones
oestrums10156463oestrums
oestrus7169573oestr_us
pestos84719083pest_o_s
petrols92913083pe_trols
petrous92714423pe_trous
postboys1585273postboys
resprays1344713resprays
restores85222983restores
restress82511773restress
restroom1047573restroom
restrooms1146033restrooms
restrove1138963restrove
retros63820193re_tro_s
strays96417933__strays
strops86220383__strops
strows96718273__strows
stroy87720393__stroy_
testcross1142543testcross
testons7313553test_ons
testoons837303testoons
troys86418613___troys
vestries11314043vestries
vestry1238623vestr_y_

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621078.71616769.4
3Display Results1071070.0333242.4
 (SQL Overall)1786911078.90520066.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.