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

160 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
diatrons93961(None) 
diatron839281diatron_
biotrons1037232biotrons
cistrons102710622cistrons
citrons92913222ci_trons
dacrons103211032d_acrons
diatoms1039072diat_oms
dictions111812672dictions
dilations102614452dilations
diurons838822di_urons
dynatrons1343392dynatrons
introns73515022_introns
matrons93517632_matrons
natrons73215662_natrons
patrons93818102_patrons
waitrons1136632waitrons
adnations1039753adnations
ailerons849853ailerons
alations82518893alations
aprons8316993__aprons
aviations12311553aviations
barons85025383_ba_rons
batons85519423_bat_ons
betatrons1145083betatrons
bevatrons1443713bevatrons
biathlons14103333biathlons
bicrons113410473bi_crons
biotron937293biotron_
bistros92810983bistro_s
cartons94122473_cartons
cations94524143_cations
cistron9299883cistron_
citations11312503citations
citrins92614363ci_trins
citron83112983ci_tron_
citrous93112993ci_trous
copatrons1346333copatrons
cratons94316033crat_ons
cuatros938273cuatro_s
dacron94310693d_acron_
daemons10269233d_aemons
dahoons1137753d_ahoons
daikons12186693d_aikons
daimons10249323d_aimons
daltons8310403d_altons
damsons1038013d_amsons
darns66927893d_a_r_ns
datos65222783d_at_o_s
dattos74311903d_atto_s
deacons10310393dea_cons
delations102616593delations
dendrons1047393dendrons
destroys1236693destroys
deuterons1046783deuterons
deviations14311163deviations
dextrans1695983dextrans
dextrins16117823dextrins
dextrous1646593dextrous
diachrony1872813diachrony
diagrams1246133diagrams
dialogs938103dia_logs
diamins10312213dia_mins
diamond1186113dia_mond
diamonds12125173dia_monds
diandrous1144583diandrous
diapasons1243203diapasons
diaphone1447103diaphone
diaphones1547443diaphones
diaphony1744123diaphony
diaries83321953dia_ries
diatom939453diat_o_m
diatonic1138683diat_onic
diatribe1145673diatribe
diatribes1245533diatribes
diatropic1445933diatropic
diazinons1941993diazinons
diazins1739183dia_zins
dictations1389703dictations
diction102313053diction_
diestrous1046603diestrous
dihedrons14113873dihedrons
dilation92215463dilation_
dilators93213203dilat_ors
dilutions10248583dilutions
dimerous1139323dimerous
dineros83812333dinero_s
dipterans1245723dipterans
dipteron1145593dipteron_
dipterous1256283dipterous
disastrous1153073disastrous
discrowns1544663discrowns
distains9413603distains
distorts91112353distorts
distrains10411333distrains
distress9311713distress
dittos74111973di_tto_s
diuron738573di_uron_
dogtrots1044693dogtrots
donations101112353donations
dotations101411633dotations
dragons938383dra_gons
dragoons1045013dragoons
durations10311463durations
dynatron1243623dynatron_
editions9310403edi_tions
elations83719123elations
enations83316903enations
fictions132410743fictions
fixations1936353fixations
flatirons1244483flatirons
garrons82713463_garrons
gigatons1046053gigat_ons
girons75014373gi__rons
hadrons113314303_hadrons
himations1438803himations
ideations1039903ideations
intron64215023_intron_
intros64215773_intro_s
irons55324133_i__rons
kations114013663_kations
ladrons83813193_ladrons
liaisons844293liaisons
libations112510443libations
ligations102111993ligations
linurons846333linurons
macrons113514893_macrons
marrons93216973_marrons
matron83918313_matron_
mediations13310983mediations
microns113814783mi_crons
midirons1145883midirons
mikrons13428413mi_krons
nations74720563_nations
natron64116023_natron_
negatrons10275843negatrons
neutrons838293neutrons
nidations1039213nidations
nitons64614903ni_t_ons
nitros64214123ni_tro_s
nitrous73512483ni_trous
orations81515803orations
ovations11149263ovations
partons94620513_partons
patrols93513513_patrols
patron84018043_patron_
patroons102710603_patroons
pistons93016373pist_ons
pitons85319043pi_t_ons
plastrons1147133plastrons
platoons1038683platoons
pliotrons1144703pliotrons
radiations11311923radiations
rations74123433_rations
ratoons73815473_ratoons
rattons73815323_rattons
stations82415223stations
tevatrons1244003tevatrons
viatores11257693viatores
viators102712023viat_ors
waitron1036333waitron_

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.423422437.4
2DLD Change Limit1461621607.98618302.3
3Display Results1601600.0602666.7
 (SQL Overall)1786911608.46921099.4
 
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.