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

205 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
dials6492534(None) 
dals57145121d_als
deals65435341deals
dhals95415441dhals
dial55935061dial_
dills65530971dills
diols65521011diols
dirls64720501dirls
duals65620081duals
rials55026671rials
sials54227241sials
vials85822381vials
aals49941142_aals
ails45654712ai_ls
als36663022__als
baals76122702baals
bails75933522bails
bals66354042_bals
biali73419072biali
bialis83617162bialis
bialy105119322bialy
bialys11387912bialys
bias64738162bia_s
bills75632862bills
birls74023162birls
coals76129602coals
dabs77139402d_abs
dads67442772d_ads
dags66642602d_ags
dahls95012282dahls
dahs88231812d_ahs
daily95922332daily
dais57040702d_ais
daks97130602d_aks
dal47554952d_al_
dale55643982d_ale
dales66439742d_ales
dams77444372d_ams
dans56748152d_ans
daps77239162d_aps
daws86638242d_aws
days87637132d_ays
deads75726912deads
deal56347412deal_
dealt65234282dealt
deans66131392deans
dears65736882dears
decals93717712decals
deils65722862deils
dells66630942dells
dels56745472d_els
denials84114132denials
dhaks13479702dhaks
dhal86719282dhal_
dialed84716452dialed
dialer74315432dialer
dialers83614302dialers
dialist8517762dialist
dialog837972dialog
dialogs938102dialogs
dialyse1135462dialyse
diary95016972diary
diazo15310032diazo
dibs76233682di_bs
dices86434242dices
dicks125824692dicks
didos76820812didos
diel59034602diel_
dies55653522di_es
diets66026642diets
diffs126315482diffs
difs86027322di_fs
digs66036052di_gs
dikes105831332dikes
dill55239972di_ll
dilly94923782dilly
dimes85833042dimes
dimly114913482dimly
dims75435022di_ms
dinars75417562dinars
dines66449152dines
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652042di_ns
dints67431312dints
diol57329132diol_
dips75536912di_ps
dirams94413702dirams
dirks105619522dirks
dirl57430022dirl_
dirts66824462dirts
dis46459892di__s
discs85316262discs
disks105417472disks
dismals102010242dismals
diss56434482di_ss
ditas65923672ditas
dites66339152dites
dits56450522di_ts
divans104612392divans
divas95418582divas
dives95832402dives
diwans105110372diwans
doats65224882doats
dolls66126922dolls
dols56943052d_ols
drabs85119672drabs
drags75521112drags
drails74716952drails
drams86025832drams
drats66628372drats
drawls105511392drawls
draws95119372draws
drays95819772drays
drills74414202drills
duads76515342duads
dual55928172dual_
duels65619232duels
dulls64523742dulls
dyads10549972dyads
fails85631482fails
fiars86720832fiars
fiats85324482fiats
fills84632372fills
fils75838692fi_ls
finals94316162finals
foals85721692foals
gals57946502_gals
gills64728192gills
girls64518392girls
goals65521292goals
hails85231642hails
heals85733452heals
hills85431352hills
ideals75012502ideals
idols65514132idols
idyls9498802idyls
ills47030422_ills
jails125422942jails
jills125122822jills
kails95525212kails
kills94526172kills
liars54723162liars
mails76037782mails
meals75933372meals
medials103914732medials
miauls8178712miauls
mills75435052mills
mils66045332mi_ls
nails55730402nails
nills54926672nills
nils46132452ni_ls
oils46337972oi_ls
opals75718352opals
orals55826482orals
ovals85413392ovals
pails75833062pails
pals66951352_pals
peals75235492peals
phials1158872phials
pial65636702pial_
pians75126962pians
pias66542552pia_s
pibals103813082pibals
pills74130972pills
pipals104213642pipals
radials83614632radials
rails55937402rails
reals55038652reals
redials84416882redials
rial45938092rial_
rias45540592ria_s
riels55121332riels
rills55032712rills
rivals94213182rivals
riyals94111082riyals
sails55738102sails
sals46851672_sals
seals54839692seals
sial45938832sial_
sills55135992sills
sisals63013572sisals
tails55634192tails
teals56234132teals
ticals83214712ticals
tills54631712tills
tils45739612ti_ls
tirls54519802tirls
trials64319882trials
urials64415192urials
vails85825932vails
veals84926192veals
vial76731092vial_
vills86429322vills
vinals94716482vinals
viols86118102viols
virls85618602virls
vitals94514302vitals
wails86631482wails
weals85428742weals
wills84528962wills
yills83921552yills
zeals145320852zeals
zills144020782zills

Search took 2 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.300595636.7
2DLD Change Limit538002051.40338346.4
3Display Results2052050.0633254.0
 (SQL Overall)1786912051.766101184.0
 
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.