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

324 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
diazins173918(None) 
diamins10312201diamins
diazin1639161diazin_
diazine1738931diazine
diazines1838701diazines
dazing175516512d_azing
diacids1137852diacids
dialing94318172dialing
dialings10329822dialings
diamin9312512diamin_
diamine10311972diamine
diamines11311622diamines
diapirs10347642diapirs
diaries83321952diaries
diazinon1842202diazinon
diazinons1941992diazinons
dioxins1568002dioxins
dizens164911392di_zens
dizzies16279752dizzies
drains73719402dra_ins
niacins938542niacins
thiazins2045302thiazins
triazins1738342triazins
aiblins9311473aiblins
ains46158883__a_ins
alanins7315803alanins
amazing1938813amazing
amazons1836643amazons
amins75534313__amins
ayins85321613__ayins
azans146516883__azans
azine146721413__azine
azines155517073__azines
azons146518253__azons
basins85722763_basins
benzins1838693benzins
bialies93618413bialies
bialis83617163biali_s
biasing103512453biasing
biffins15358533biffins
biggins113410693biggins
biotins93114453biotins
blains84516373bla_ins
blazing193612393blazing
blazons1836163blazons
brains85125473bra_ins
brazens18418713brazens
brazils1867753brazils
brazing193715113brazing
cabins104418913_cabins
cains75334303_ca_ins
chains114819703cha_ins
chazans21268123chazans
citrins92614363citrins
crazies183413853crazies
crazing193914583crazing
cyanins122910013cyanins
daidzeins2041313daidzeins
daikons12186693daikons
dailies84219263dailies
daimios1035753daimios
daimons10249323daimons
dairies84217733dairies
dais57040703d_a_i_s
daisies84217093daisies
damans94715983d_amans
damns84916923d_a_mns
danios7314603d_anios
dans56748143d_a__ns
darics94314113d_arics
daring84928683d_aring
darings93713643d_arings
darns66927893d_a_rns
dating85326483d_ating
davens104612913d_avens
davies105020513d_avies
davits104012363d_avits
dawing114819823d_awing
dawns95916593d_a_wns
dazes155024143d_az_es
deacons10310393deacons
deadens93410693deadens
deafens11317253deafens
deairs74013783dea_irs
dealing94323233dealing
dealings103510693dealings
deaning94020473deaning
deans66131393dea__ns
dearies83526273dearies
deaving123814753deaving
dentins83419223dentins
detains83716093detains
deveins1138803deveins
dezinc1836053d_ezinc
dezincs1933753d_ezincs
diacid10310633diaci_d
diadems1135393diadems
dialers83614293dialers
dialist8517763dialist
dialists9411413dialists
dialling10310783dialling
diallings1134993diallings
dialogs938103dialogs
dials64925343dia__ls
dialyzing2344043dialyzing
diamide1138473diamide
diamides1238813diamides
diamond1186113diamond
diamonds12125173diamonds
diapers104713893diapers
diapir9357113diapi_r
diapsids1244753diapsids
diarist8517113diarist
diarists9410363diarists
diatoms1039073diatoms
diatrons939613diatrons
diazo15310033diaz__o
diazole1736793diazole
diazoles1836323diazoles
dibbing133110883dibbing
dicing105718763di_cing
dickens144410133dickens
dickies143416343dickies
dicking153617613dicking
dicliny1337673dicliny
dictions111812673dictions
didies84621833di_dies
dieing84018653di_eing
diesis74013493diesi_s
dieting93616833dieting
digamies1238623digamies
digging113513703digging
diggings12316623diggings
digits84114533di_gits
digoxins1744293digoxins
dikdiks1242563dikdiks
diking124320243di_king
dilating102714903dilating
dilations102614453dilations
dillies84122153dillies
dimming13339583dimming
dimwits1344503dimwits
dingies93618243dingies
dinging103618613dinging
dining84525133di_ning
dinkies123716033dinkies
dinking133618283dinking
dinning93416553dinning
dins56652043d___ins
dinting93520553dinting
dioxans1555313dioxans
dioxids1655683dioxids
dioxin14118783dioxin_
dipping134014833dipping
dirking133812603dirking
dirling93316073dirling
dirties83119383dirties
discing113914593discing
disdains1037913disdains
dishing124017103dishing
disjoins1647623disjoins
disking134615493disking
dislimns1144813dislimns
dismiss1038153dismiss
disowns1136733disowns
dissing94517683dissing
distains9413603distains
distils83015803distils
ditties83116983ditties
ditzes163212423ditz_es
ditzier17307963ditzier
ditziest18218473ditziest
ditziness1945883ditziness
diurons838823diurons
divans104612393di_vans
divine103514463di_vine
divines113514723di_vines
diving113717953di_ving
divvies1457663divvies
diwans105110373di_wans
dixits144210313di_xits
dizen155214933di_zen_
dizzied17236133dizzied
dizzier16317543dizzier
dizziest17266723dizziest
dizzily1934843dizzily
dizziness1834183dizziness
dizzying2133023dizzying
djins1368453d__jins
doating93816863doating
dobbins12379533dobbins
domains10510873domains
doozies173812723doozies
dormins10311273dormins
dozens164612463d_ozens
dozing174214193d_ozing
dragons938383dragons
drails74716953dra_ils
drain65222893dra_in_
draping114213353draping
drawing123812053drawing
drawings13386273drawings
draying123813843draying
dubbins12358803dubbins
dunlins849553dunlins
dyadics1453473dyadics
dyneins1134213dyneins
elains64919853ela_ins
etamins91511823etamins
fagins10513863_fagins
fazing194418643_fazing
feazing205411443feazing
fibrins1238633fibrins
ficins113513983fi_cins
firkins1437663firkins
fizzing19276403fizzing
flavins1338543flavins
frazils1956123frazils
gains65729513_ga_ins
gamins94420043_gamins
gazing174717173_gazing
ghazies2036913ghazies
ghazis1935193ghazi_s
glazing183611003glazing
glazings19325753glazings
gliadins1035193gliadins
gradins93416233gradins
grains74223093gra_ins
gratins84119183gratins
grazing183514553grazing
grazings19337253grazings
guanins8810013guanins
hazans183411653_hazans
hazing194218553_hazing
hazings20378343_hazings
hoatzins2043833hoatzins
hyalins13229273hyalins
iodins74216513_iodins
isatins7310773isatins
kains96125643_ka_ins
khazens2332663khazens
kinins104014583ki_nins
lapins84520683_lapins
layins93817653_layins
lazies154418783_lazies
lazing164821473_lazing
lignins84010493lignins
linins65922143li_nins
lipins85016883li_pins
mains75635093_ma_ins
matins84527783_matins
mavins115119183_mavins
mazing184418973_mazing
mirins83918893mi_rins
mizens174610253mi_zens
mizzens17366123mizzens
nazis145216083_nazi_s
niacin8310223niacin_
oxazine2354773oxazine
oxazines2434073oxazines
pains75138283_pa_ins
patins87528783_patins
pavins114919663_pavins
pians75126963pia__ns
piazzas1743643piazzas
pidgins11259123pidgins
piggins113010473piggins
pipkins15328183pipkins
pippins10319753pippins
plains85019593pla_ins
rains55140233_ra_ins
raisins72715343raisins
ravins94622563_ravins
rawins95617623_rawins
razing164524543_razing
reagins84215643reagins
ricins83618703ri_cins
sabins85521973_sabins
saimins9312113saimins
sains55639973_sa_ins
sarins63932623_sarins
sasins64923103_sasins
satins64930483_satins
savins93923133_savins
seizins164010133seizins
sialids839723sialids
simazine1945363simazine
simazines2044863simazines
simlins9311823simlins
siskins1159583siskins
sizing163616443si_zing
sizings17378013si_zings
sozins15510783_sozins
spavins12419323spavins
stains64923653sta_ins
statins73719773statins
swains94513953swa_ins
tains54936323_ta_ins
takins105117403_takins
thiamins1346603thiamins
thiazin1945453thiazin_
thiazine2045243thiazine
thiazines2144623thiazines
tiepins939463tiepins
tiffins13327983tiffins
tizzies15287893tizzies
trains64725343tra_ins
triazin1638193triazin_
triazine1738503triazine
triazines1847543triazines
twains95811183twa_ins
vialing113614163vialing
violins10311453violins
virgins1137863virgins
vitamins1347083vitamins
vizirs18306713vi_zirs
wains86930863_wa_ins
withins133511693withins
wizens186110263wi_zens
wizzens18385483wizzens
zayins18409713_zayins
zazens1435833_zazens
zeatins16311733zeatins
zins135735003___zins

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273246.32621186.7
3Display Results3243240.1262571.4
 (SQL Overall)1786913246.60827041.6
 
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.