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

190 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
heils8522219(None) 
ceils75019401ceils
deils65722861deils
hails85231641hails
heals85733461heals
heels85625531heels
heil76328931heil_
heirs85618561heirs
hells85032041hells
herls85226431herls
veils84918801veils
ails45654722_ails
anils56326722anils
arils58732202arils
axils127217502axils
bails75933522bails
bells76432162bells
bels66142492be_ls
bezils1711310602bezils
boils75427192boils
ceil65725062ceil_
ceili75814792ceili
ceilis85413742ceilis
cells75428062cells
cels65534972ce_ls
chiels115115932chiels
coils75030082coils
deals65435342deals
deil56231622deil_
delis64928542delis
dells66630942dells
dels56745472de_ls
devils104412812devils
eels46536742_eels
ells46431352_ells
els37645722_e_ls
evils84114262evils
fails85631482fails
feels85223042feels
fells85327382fells
fils75838702_fils
foils85025812foils
gels56836102ge_ls
haiks125120932haiks
hail74839062hail_
hairs86225172hairs
halls85633782halls
harls85634502harls
hauls86123732hauls
heads95127112heads
heal75645692heal_
heaps105223222heaps
hears86737372hears
heats85838402heats
hebes105521672hebes
hecks145220652hecks
heeds95420422heeds
heel75034222heel_
hefts116218152hefts
hehs106723962he_hs
heigh124812542heigh
heiled104415612heiled
heir77523802hei_r
heist87030912heist
heists96814632heists
held85330402he_ld
helio85321192helio
helios94816632helios
helix154413012helix
hell75637892he_ll
hello86522982hello
hellos95321682hellos
helm95530022he_lm
helms105619462helms
helo75332852he_lo
helos84928062helos
help95328922he_lp
helps105219342helps
hemes105031082hemes
hemins113417572hemins
hemps126917332hemps
hems95534942he_ms
hens75642572he_ns
hents87330742hents
herbs105520502herbs
herds96424682herds
heres86245902heres
herl75834552herl_
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872he_rs
hes66654202he__s
hests85829932hests
heths116317782heths
hets75547202he_ts
hews105631572he_ws
hexes155123042hexes
hexyls1933442hexyls
hies74842842h_ies
hila76228362h_ila
hili75626642h_ili
hill76439502h_ill
hills85431352hills
hilt75850722h_ilt
hilts86924412h_ilts
hilus84817642h_ilus
hims95230982h_ims
hins76448002h_ins
hips96433712h_ips
his66359512h_i_s
hiss75629222h_iss
hits75545142h_its
hols76946292h_ols
howls116219222howls
hulls84923562hulls
hurls86522712hurls
jails125422942jails
jells125522162jells
kails95525222kails
keels94622412keels
keirs95313682keirs
kevils13358332kevils
leis45739602lei_s
mails76037782mails
meals75933382meals
mells75031332mells
mels65941532me_ls
merls77423902merls
mewls105813232mewls
mils66045342_mils
moils76125752moils
nails55730402nails
neifs85613042neifs
nils46132462_nils
noils55024332noils
oils46337982_oils
pails75833062pails
peals75235492peals
peels75226422peels
peins76128062peins
perils84121852perils
rails55937402rails
reals55038652reals
reels55333262reels
reifs84819092reifs
reins56234562reins
reis45343232rei_s
reoils64516872reoils
riels55121332riels
roils54826792roils
sails55738102sails
seals54839702seals
seels55632822seels
seifs85019332seifs
seis45542392sei_s
sells55134432sells
sels46345982se_ls
sheals94420642sheals
sheiks132510012sheiks
sheila969842sheila
sheilas1059402sheilas
shells94319522shells
sheols94614162sheols
shiels95418922shiels
soils55327982soils
speils84116222speils
tails55634192tails
teals56234132teals
teels55726372teels
tells55828942tells
tels46841692te_ls
theins95015422theins
theirs94610352theirs
tils45739622_tils
toils54527492toils
vails85825932vails
veals84926192veals
veil75523592veil_
veins84620492veins
vexils1647172vexils
wails86631482wails
weals85428742weals
weirs84316492weirs
wells85426192wells
wheals124512522wheals
wheels123811722wheels
yells85821942yells
zeals145320852zeals
zeins144715392zeins

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.313570897.8
2DLD Change Limit538001901.65632487.9
3Display Results1901900.0603166.7
 (SQL Overall)1786911902.02988068.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.