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 “examined” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
examined1813586(None) 
examine161510031examine_
examinee17156581examinee
examiner17145461examiner
examines17128791examines
enamine91214312enamine_
enamines101112132enamines
ermined10410602e_rmined
etamine91313072etamine_
etamines101611812etamines
examinees18123782examinees
examiners18124432examiners
exampled2043352exampled
hexamine2046872hexamine_
hexamines2146202hexamines
reexamined2052892reexamined
unexamined2042572unexamined
alined75221403__alined
amine75835383__amine_
amines84727983__amines
basined10310003_basined
bedamned1434583bedam_ned
brained103816103bra_ined
cabined1239993_cabined
calamined1447433calamined
chained133812693cha_ined
damned104212913_dam_ned
detained103111643deta_ined
diamine10311983diamine_
diamines11311643diamines
drained93713253dra_ined
earned74818333e_a_rned
elapine9310673elapine_
eloined8149813e_loined
emailed10359213ema_iled
enameled1136373enameled
enamored1147033enamored
engined9119893e_ngined
enjoined16215723enjoined
entwined1235843entwined
ermine8416923e_rmine_
ermines9416673e_rmines
estaminet1149693estaminet
etamin81311853etamin__
etamins91511833etamin_s
exacted1737303exa_cted
exalted1537393exa_lted
examen1538283exam__en
examens1637193examen_s
examinant1844603examinant
examining1945143examining
example1844283example_
examples1944313examples
exapted1736073exa_pted
excided1836203ex_cided
excised1736673ex_cised
excited1737853ex_cited
exempted2044143exempted
exiled144712463ex__iled
exine125518493ex__ine_
exines135715803ex__ines
exited144712523ex__ited
expired1736403ex_pired
explained1944543explained
exscind1743753exscin_d
exscinded2042223exscinded
extermined2045323extermined
famine114318193_famine_
famines123216263_famines
flamines13311643flamines
fulmined1454333fulmined
gained84617463_ga_ined
gamine94620153_gamine_
gamines103618463_gamines
grained93814273gra_ined
imagined1254783imagined
ketamine14157053ketamine_
ketamines15177033ketamines
melamine12310303melamine_
melamines1339763melamines
mined85333353___mined
oxazine2354773oxazine_
oxazines2434073oxazines
pained95622853_pa_ined
patined105114783_patined
plained103812233pla_ined
rained75024603_ra_ined
ravined115411823_ravined
reexamine1844493reexamine_
reexamines1953873reexamines
regained102111243rega_ined
relumined1245363relumined
remained112412893rema_ined
retained93016093reta_ined
sained75424243_sa_ined
spavined1434333spavined
stained84215343sta_ined
stamened1137633stamened
trained84117203tra_ined
unmined102612953_unmined

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.470380193.6
2DLD Change Limit1461621007.87618557.9
3Display Results1001000.0303333.3
 (SQL Overall)1786911008.37621333.7
 
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.