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

121 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
atropins1041049(None) 
atropin9311581atropin_
atropine10410111atropine
atropines1148881atropines
tropins93116311_tropins
atopies92816432at_opies
atrophias1447932atrophias
atrophies14410092atrophies
atropism1247992atropism
atropisms1347112atropisms
tropics113610652_tropics
tropin83316752_tropin_
tropine93116652_tropine
tropines102214922_tropines
abrosias1049033abrosias
acrasins1039973acrasins
acrogens1147243acrogens
acroleins1145543acroleins
adjoins1585983adjo_ins
aerobics1246833aerobics
aloins65022203a_lo_ins
ametropias1454783ametropias
anopias92412483a_nopias
aproning11311793aproning
aprons8316993apro__ns
apropos1138843aprop_os
armpits1157133a_rmpits
aroids75118223a_ro_ids
aroint6328153a_ro_int
aroints7313133a_ro_ints
arpens84814823a_r_pens
arrowing1237943arrowing
arshins10312573a_rshins
atomics113110853at_omics
atomies93918363at_omies
atonias73315993at_onias
atonics93613713at_onics
atonies75320953at_onies
atoning83514873at_oning
atopic103514143at_opi_c
atrazine1748403atrazine
atrazines1846683atrazines
atresias839473atresias
atrocious1146043atrocious
atrocity1347213atrocity
atrophia1348103atrophia
atrophic1549373atrophic
atrophied1546063atrophied
atrophy1546183atrop_hy
atrophying1943533atrophying
attains7310983at_tains
attorns738443atto_rns
autopens1046633autopens
bromins112513783_bromins
carotins102315583carotins
carrotins11239963carrotins
chopins142312243_chopins
entropies11411023entropies
entropions12105743entropions
groins73917203_gro_ins
groping113313103_groping
hairpins1365433hair_pins
harpins123615703har_pins
hatpins123410643hat__pins
heroins103518013hero_ins
matrons93517633matro__ns
meropias1249963meropias
natrons73215663natro__ns
orpins83614163_or_pins
patrons93818103patro__ns
patroons102710603patro_ons
propine113020213_propine
propines122618933_propines
repins84924313__repins
robins83617453__robins
roping94023023__roping
rosins64521863__rosins
satrapies1147713satrapies
stooping113012363stooping
stoping103716623st_oping
stotins73213873st_otins
strains74218153str_ains
striping112612523striping
stripings12215203stripings
strobils1046563strobils
stroking132610943stroking
strophes13310603strophes
stropping1436933stropping
strops86220383strop__s
strowing122310563strowing
stroying122410593stroying
taborins103310223taborins
tarpans92513533tar_pans
tarpons92612213tar_pons
tenpins9410073_tenpins
teopans939203_teopans
tiepins939463_tiepins
topics104714583_t_opics
toping94122993_t_oping
topis76025833_t_opi_s
torpids1037373_torpids
toxins133314283_t_oxins
trains64725343_tr_ains
trapans92812463_trapans
trepans92311593_trepans
trogons83410723_trogons
trois57226093_tro_i_s
troking123514103_troking
tromping13319603_tromping
trooping112710283_trooping
tropes84824353_trop_es
trophies13413673_trophies
tropic103014193_tropi_c
tropism1139293_tropism
tropisms1247723_tropisms
troponins1147203_troponins
trouping11249503_trouping
trowing113413703_trowing
trypsins1344903_trypsins
utopians1094903ut_opians
utopias9117723ut_opias

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621216.64022012.3
3Display Results1211210.0502420.0
 (SQL Overall)1786911217.09625181.9
 
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.