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

174 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
holies9463003(None) 
colies84837051colies
holes84748651hol_es
holier94921621holier
holiest104319621holiest
hollies103420811hollies
homies114524721homies
molies84429511molies
polies84034581polies
allies63827672allies
belies84631052belies
bodies94524142bodies
bogies94724312bogies
boles75448602bol_es
bolides10515072bolides
chilies124218302chilies
cholines132214492cholines
coles76055062col_es
colics104219902colics
colins85229042colins
collies94326582collies
conies84338592conies
coolies93824962coolies
copies104130302copies
cosies84932152cosies
cozies174521412cozies
dholes104914792dhol_es
dhoolies1246962dhoolies
dobies94422092dobies
dogies85022252dogies
doilies84017362doilies
doles67843752dol_es
dollies83620982dollies
doolies83920712doolies
dories75232362dories
doxies143917852doxies
doylies114512572doylies
flies85630712_flies
fogies104118062fogies
folios93915462folios
folkies143612252folkies
folles93820472folles
follies103618942follies
ghoulies1235392ghoulies
goalies8316022goalies
gobies95418062gobies
hales85449842hal_es
halides113416662halides
halids104016132halids
halites103221192halites
haloes94623862haloes
halves124717092halves
haoles94919802haol_es
helices12313722helices
helios94816632helios
helixes1739132helixes
helves124316062helves
hies74842832h__ies
hoagies112811992hoagies
hoaxes163611692hoaxes
hobbies143813342hobbies
hoboes114717442hoboes
hoes75755732ho__es
hogties112813992hogties
hoise85224772ho_ise
hoises94823672hoises
hokes126231642ho_kes
hokier134214032hokier
hokiest144114242hokiest
holden104113952holden
holder104619652holder
holders113715902holders
holds94623242hol_ds
hole77553392hol_e_
holed95634132hol_ed
holey115626902hol_ey
holily123612952holily
holiness112512502holiness
holing104025072holing
holism113713742holism
holisms123811112holisms
holist94723212holist
holists104413962holists
holked144913662holked
holks124720562hol_ks
hollas94616902hollas
holler93520612holler
hollers103818232hollers
holloes103818192holloes
hollos95320632hollos
holms105117802hol_ms
holpen11299412holpen
hols76946292hol__s
holts85627912hol_ts
homes106938812ho_mes
homie104622522homie_
homier116416992homier
homiest124116632homiest
homilies132710112homilies
homines123518642homines
hones88144492ho_nes
hongies112716472hongies
honied104818392honied
honkies143015142honkies
hoodies113419832hoodies
hookies144017442hookies
hoolie93217772hoolie_
hooves124815482hooves
hopes105835642ho_pes
hoplites13310542hoplites
hordes104921632hordes
horses94729342horses
hoses85443172ho_ses
hosier94219612hosier
hosiers104212632hosiers
hotlines11811642hotlines
hotties103016952hotties
hourlies1138342hourlies
houses96032272houses
howdies142911952howdies
howes114730262ho_wes
hoyles12315012hoyles
hurlies103315332hurlies
iolites73819482iolites
joles125230832jol_es
jollies143516272jollies
lies46454192__lies
lilies63021412lilies
lollies73116922lollies
looies65025832looies
lories64933042lories
louies64525102louies
moles74747922mol_es
mollies93420232mollies
monies83233162monies
movies115118452movies
moxies154317402moxies
oldies7314422_oldies
oles46453472_ol_es
olios54520852_olios
olives94313952_olives
oolites72817842oolites
phonies123717512phonies
plies74526512_plies
pogies94123542pogies
pokies125921332pokies
poleis86018352poleis
poles75351002pol_es
polices113118052polices
polios84019722polios
polis74731162poli_s
ponies84833462ponies
posies84431432posies
relies65036422relies
roles56747982rol_es
soles55547922sol_es
solids74116402solids
solves95018222solves
tholes94919782thol_es
tobies84521022tobies
todies74223552todies
toiles63923512toiles
toles55147132tol_es
tories65435882tories
towies93521192towies
uglies7412322uglies
voiles94616442voiles
voles86234042vol_es
voltes94915582voltes
walies95324522walies
wholes124616772whol_es
wolves124510852wolves
woolies104117362woolies
yowies123913732yowies

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 Filter178691825510.1431249587.4
2DLD Change Limit825511742.15338342.3
3Display Results1741740.0632761.9
 (SQL Overall)1786911742.35975748.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.