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

290 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
diuron73857(None) 
diurons838821diurons
bicron103710772bicron
citron83112982citron
dacron94310692dacron
diatron839282diatron
durion7510962d_urion
durn56127622d_ur_n
duro56228022d_uro_
duroc84513142d_uroc
duros65422692d_uros
giron66118992gi_ron
iron46728462_i_ron
linuron746512linuron
micron103714282micron
mikron12318502mikron
neuron6310372neuron
adjuror1542893adjuror
aileron739833aileron
airn46433833ai_r_n
aleuron757383aleuron
andiron848283andi_ron
anuran64313243anuran
apron7318833_apron
baron78131243_baron
bicorn103610103bicorn
bicrons113410473bicrons
billon83713833billon
biotron937293biotron
biro66131213bi_ro_
biros75325133bi_ros
bison75716983bi_son
boron76727143_boron
bourbon1135813bourbon
bourdon1036423bourdon
bourn75518483bour_n
bouton8311533bouton
buran75225303_buran
burin75626063_burin
burn65636423_bur_n
burton8311273_burton
churn105113103chur_n
cion613330913ci__on
cistron9299883cistron
citrin82615413citrin
citrons92913223citrons
coupon102810993coupon
curn66731883_cur_n
dacrons103211033dacrons
daemon9279593daemon
dahoon1039053dahoon
daikon11217243daikon
daimon9259713daimon
dalton7311273dalton
damson938063damson
darn56434623d_ar_n
deacon9510423deacon
decrown13206053decrown
decurion1146623decurion
dehorn10439653dehorn
demon86520313d_emon
dendron947653dendron
deuteron945993deuteron
devon95113683d_evon
dhurna1043563dhurna
dialog837973dialog
diamin9312523diamin
diamond1186113diamond
diary95016973diar_y
diatom939453diatom
diatrons939613diatrons
diazin1639163diazin
diazo15310033diazo_
dicot85429093di_cot
diction102313053diction
dido66528193di_do_
didos76820813di_dos
diglot83014333diglot
dihedron13104113dihedron
dildo71911773dildo_
dildoe8198673dildoe
dildos8179303dildos
dilution9239143dilution
dilutor8256013dilutor
diluvion12215413diluvion
din46459463di___n
dinero75612643dinero_
dineros83812333dineros
dingo74720793dingo_
dino56036753di_no_
dinos65428063di_nos
diobol936883diobol
diol57329133di__ol
dioxan1465773dioxan
dioxin14118783dioxin
diploe9810153diploe
diplont10311693diplont
dipnoan1044653dipnoan
dipso85111553dipso_
dipsos95310053dipsos
dipteron1145593dipteron
diram84419473di_ram
dire56644143di_r_e
direr64927073di_rer
dirge75117073di_rge
dirk96326833di_r_k
dirks105619523di_rks
dirl57430023di_r_l
dirls64720503di_rls
dirt55550383di_r_t
dirts66824463di_rts
dirty95617803di_rty
disco85616073disco_
discos94915213discos
discrown1445283discrown
disjoin1547643disjoin
disown1036953disown
disrobe1038993disrobe
disroot8413563disroot
disunion956113disunion
ditto65315603ditto_
dittos74111973dittos
diurnal844883diurnal
divan96114843di_van
divot95723073di_vot
diwan95712553di_wan
dizen155214933di_zen
doblon938013doblon
dobro84412213dobro_
dobros93910233dobros
dobson936593dobson
don46757653d___on
donjon1436463donjon
dour56330433dour__
doura66518663dour_a
dourah10479813dourah
douras75016723douras
dourer74215273dourer
dourine8311453dourine
dourly103210433dourly
dragon838843dragon
dromon939363dromon
drone65324983d__rone
drop75324403d__rop
drown95515823d__rown
dugong934373d_ugong
dun46545583d_u__n
duo48536143d_u_o_
duos56728133d_u_os
dura55232113d_ur_a
dural64923893d_ural
duras65727723d_uras
dure56341813d_ur_e
dured75025403d_ured
dures65635923d_ures
durian7312003d_urian
during84419403d_uring
durions839963d_urions
durns64819863d_urns
durocs9569703d_urocs
durr55624353d_ur_r
durra65315793d_urra
durrs65519993d_urrs
durst66125173d_urst
durum8513203d_urum
edition8310853edition
eikon939463ei_kon
euro45325273_euro_
euros54920243_euros
fenuron1075153fenuron
fibrin1138533fibrin
fibroin1246473fibroin
firn76927503fi_r_n
fleuron1055573fleuron
fourgon1134863fourgon
furan84320013_furan
furor8312393_furor
futon83113773_futon
garron73113493garron
gibbon1135323gibbon
gibson935123gibson
gipon84212413gi_pon
girn56026863gi_r_n
giro55828633gi_ro_
girons75014373gi_rons
giros65722653gi_ros
gluon6311223glu_on
guidon837373guidon
guiro63712093guiro_
guiros7389093guiros
gyron95314623_gyron
hadron102913753hadron
heron85025503_heron
icon66922043_i_con
ikon85814953_i_kon
inion54620183_inion
inro45920793_inro_
inrun52911373_inrun
intron64215023intron
inurn53712863inur_n
ion36051023_i__on
irone55126363_i_rone
irons55324133_i_rons
irony85015903_i_rony
journo13135293journo
jupon14479193_jupon
juror1239563_juror
kirn87123433ki_r_n
kouroi1036513kouroi
kouros1039183kouros
ladron73413323ladron
leukon1036143leukon
ligroin848043ligroin
linurons846333linurons
lion46334443li__on
lirot5430033li_rot
macron103615673macron
marron83717543marron
matron83918313matron
micro94715993micro_
microns113814783microns
micros104115363micros
midiron1046003midiron
mignon937953mignon
mikrons13428413mikrons
minion83416243minion
mirin75023153mi_rin
mirror848003mirror
monuron937463monuron
moron76925423_moron
mourn77215013mour_n
mouton8410853mouton
muon65722733_mu_on
muton73817003_muton
natron64116023natron
neurone739433neurone
neurons7410443neurons
neutron737763neutron
nimrod934873nimrod
ninon55517383ni_non
niton55418283ni_ton
nitro54914353nitro_
nitros64214123nitros
omicron1165063omicron
omikron1353173omikron
operon8811773operon
patron84018043patron
perron83216623perron
pigeon949413pigeon
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235293pi__on
pirn67128373pi_r_n
pirog83913673pi_rog
piston83515923piston
piton76121583pi_ton
pleuron976343pleuron
pluton838853pluton
purin75527593_purin
puton73617913_puton
ribbon1036533ribbon
sadiron836043sadi_ron
simoon858063simoon
siphon1138463siphon
siren54525823si_ren
spurn74815453spur_n
tauon54816583tau_on
thoron94713903thoron
tiglon737923tiglon
tigon63914443ti_gon
tiro46832363ti_ro_
tiros54524893ti_ros
turion6313163_turion
turn46330383_tur_n
turnon638193_turnon
udon56017743__udon
upon65817583__upon
urn35731463__ur_n
vibrion1245253vibrion
virion9310683virion
vision9311313vision
voudon1035873voudon
waitron1036333waitron
wigeon1037223wigeon
yaupon11345493yaupon
youpon11366003youpon
yourn87512773your_n
yupon10469483_yupon
zircon1754953zircon

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162904.83023336.6
3Display Results2902900.0763815.8
 (SQL Overall)1786912905.04635412.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.