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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

176 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
diols6552101(None) 
dials64925341dials
dills65530971dills
diol57329131diol_
dirls64720501dirls
dols56943051d_ols
idols65514131idols
viols86118101viols
adios65822862adio_s
ails45654712ai_ls
aioli5318312aioli
aiolis6316842aiolis
awols84713522awols
bills75632862bills
biogs85016112biogs
bios66335322bio_s
birls74023162birls
boils75427192boils
cibols1039522cibols
cions75222852cions
coils75030082coils
cols66553082_cols
cools75632632cools
dahls95012282dahls
dals57145122d_als
deals65435342deals
deils65722862deils
dells66630942dells
dels56745472d_els
dhals95415442dhals
dhole95215362dhole
dholes104914792dholes
dhows125911222dhows
dial55935062dial_
dibs76233682di_bs
dices86434242dices
dicks125824692dicks
dicots94915792dicots
didoes85716962didoes
didos76820812didos
diel59034602diel_
dies55653522di_es
diets66026642diets
diffs126315482diffs
difs86027322di_fs
digs66036052di_gs
dikes105831332dikes
dill55239972di_ll
dilly94923782dilly
dimes85833042dimes
dimly114913482dimly
dims75435022di_ms
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042di_ns
dints67431312dints
diobols1036542diobols
diode74716112diode
diodes83915782diodes
dipole91112852dipole
dipoles101013752dipoles
dips75536912di_ps
dirks105619522dirks
dirl57430022dirl_
dirts66824462dirts
dis46459892di__s
discs85316262discs
disks105417472disks
diss56434482di_ss
ditas65923672ditas
dites66339152dites
dits56450522di_ts
divas95418582divas
dives95832402dives
divots104712202divots
docs75631152d_ocs
does56554472d_oes
dogs66440152d_ogs
doily95321032doily
doits66223672doits
dol47150652d_ol_
dole56550002d_ole
doles67843752d_oles
doll56632492d_oll
dolls66126922dolls
dolt56649422d_olt
dolts65626312d_olts
doms76239572d_oms
dons56048702d_ons
dooly94821802dooly
dooms85321342dooms
doors65022132doors
dors56747602d_ors
dos48062312d_o_s
doss56235042d_oss
dots55647662d_ots
dows85941052d_ows
drills74414202drills
droll65415402droll
drolls75312392drolls
drools74412812drools
drops85719502drops
dross65418092dross
duals65620082duals
duels65619232duels
dulls64523742dulls
duos56728132duo_s
enols54718402enols
fills84632372fills
filos86125382filos
fils75838692fi_ls
foils85025812foils
fools86824202fools
gaols66717572gaols
gills64728192gills
girls64518392girls
hills85431352hills
hols76946292_hols
idioms956412idioms
idiots768642idiots
idol56818632idol_
idyls9498802idyls
ills47030422_ills
ions46737852_ions
jills125122822jills
kills94526172kills
kilos95021472kilos
lilos55821872lilos
lions55923212lions
mills75435052mills
milos75428012milos
mils66045332mi_ls
moils76125752moils
mols65948572_mols
mools76027172mools
nicols8810242nicols
nills54926672nills
nils46132452ni_ls
noils55024332noils
obols73715862obols
odious749932odious
oils46337972oi_ls
pills74130972pills
pions75826392pions
pious74621272pious
pols66044562_pols
pools74427702pools
rials55026672rials
riels55121332riels
rills55032712rills
riots54922012riots
roils54826792roils
sials54227242sials
sills55135992sills
silos56029432silos
soils55327982soils
sols45448162_sols
thiols95112762thiols
tills54631712tills
tils45739612ti_ls
tirls54519802tirls
toils54527492toils
tools55325242tools
triols66117802triols
vials85822382vials
vills86429322vills
viol76523592viol_
viola85915542viola
violas93713522violas
virls85618602virls
wills84528962wills
wools84421462wools
yills83921552yills
zills144020782zills

Search took 3 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 Filter178691538000.0961861364.6
2DLD Change Limit538001762.20324421.2
3Display Results1761760.0463826.1
 (SQL Overall)1786911762.34576200.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.