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

187 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
hennaing123499(None) 
denning93515172denn_ing
henting113719652he_nting
hinnying15124852hinnying
kenning124010542kenn_ing
penning103616492penn_ing
yenning11369492yenn_ing
banning103818233bann_ing
beaning103820683bean_ing
benaming1339693benaming
benching163411343benching
bendaying1634953bendaying
bending114420893be_nding
binning103615453binn_ing
canning103620133cann_ing
censing104215263ce_nsing
centring112112953centring
chinning14329653chinn_ing
congaing1239823congaing
conning103718753conn_ing
cunning104214623cunn_ing
deaning94020473dean_ing
denoting10311753denoting
denting94422183de_nting
denuding1137113denuding
denying123711293de_nying
dinning93416553dinn_ing
donning93512763donn_ing
dunning93514473dunn_ing
eanling81416673_eanling
encaging1258733_encaging
encasing11610823_encasing
ending83220253_e_nding
enduing9249723_enduing
enfacing1467293_enfacing
engaging1147373_engaging
enlacing1148773_enlacing
enraging1049573_enraging
ensnaring1046383_ensnaring
ensuing8239543_ensuing
enuring8813883_enuring
envying1435713_envying
fanning113615073fann_ing
feinting123410833feinting
fencing132411133fe_ncing
fending123717603fe_nding
finning113615113finn_ing
funning113813613funn_ing
gentling1048453gentling
ginning93313983ginn_ing
gunning93413173gunn_ing
handing123518893h_anding
handling132312713handling
hangaring1438033hangaring
hanging123518703h_anging
hanking154619103h_anking
hanting114124483h_anting
haunting123510053haunting
heading122919113he_ading
healing113922963he_aling
heaping133015853he_aping
hearing113324163he_aring
hearsing1239383hearsing
hearting12513123hearting
heating114024323he_ating
heaving144114763he_aving
heckling18257163heckling
hedging13348953he_dging
heeding123515063he_eding
heehawing1943183heehawing
heeling113618513he_eling
heezing20349873he_ezing
hefting144510913he_fting
heiling113616363he_iling
heiring113312903he_iring
heisting123411043heisting
helling114623223he_lling
helloing12159123helloing
helming133712003he_lming
helping133512223he_lping
helving144011133he_lving
hemming15269973he_mming
henbane1237353henba_ne
henna84414043henna___
hennaed1135103henna_ed
hennas94211803henna__s
hennish1336863henn_ish
herding122915123he_rding
herniating1445983herniating
herring113615883he_rring
herrying15147023herrying
hewing134514243he__wing
hexing174210513he__xing
hinging123917123h_inging
hinting113919223h_inting
hollaing12167103hollaing
hondling132210013hondling
honeying1537673honeying
hongiing1335603hongiing
honing103421503h_on_ing
honking153414793h_onking
honoring12310473honoring
horning113015003horn_ing
hosannaing1451513hosannaing
hounding132610053hounding
hunching17309113hunching
hunting114317123h_unting
huzzaing2042433huzzaing
hymning1635183hymn_ing
inning73617633_inn_ing
keening123713153keen_ing
kenneling1464083kenneling
kennings13315273kenn_ings
kerning124010893kern_ing
leaning83721203lean_ing
lending94118533le_nding
leniting9312353leniting
lensing84015103le_nsing
manning103616383mann_ing
meaning103918703mean_ing
menacing1339783menacing
mending114018683me_nding
mensing103915103me_nsing
panning104019393pann_ing
peening103318303peen_ing
peining104619153pein_ing
penancing1436343penancing
penang92511113pe_na_ng
pending114119773pe_nding
pennant9312493penna_nt
pennine93712953penn_ine
petnaping1444543petnaping
pinning103417853pinn_ing
punning103414993punn_ing
recaning111416693recaning
reining84425323rein_ing
reinking13311023reinking
renaming11313693renaming
rending93924263re_nding
reneging102111533reneging
renewing121910713renewing
rennin63914033renn_in_
rennins74013413renn_ins
renting84026853re_nting
rinning83216743rinn_ing
running83514593runn_ing
saunaing937013saunaing
seining84020773sein_ing
sending94221373se_nding
sensating1039253sensating
sensing84116953se_nsing
sheening123010803sheen_ing
shending132511253she_nding
shinning123211023shinn_ing
shinnying16193723shinnying
shunning12367843shunn_ing
sinning83918443sinn_ing
sunning83715673sunn_ing
tanning83618253tann_ing
tenanting1036213tenanting
tending94419163te_nding
tenoning938893tenoning
tensing84616653te_nsing
tenting84621153te_nting
tenuring938863tenuring
thinning12319093thinn_ing
tinning83117283tinn_ing
tunning83514453tunn_ing
unending10239943unending
vanning113912463vann_ing
veining114713893vein_ing
vending124015263ve_nding
venenating1446013venenating
venging123710943ve_nging
venoming1436403venoming
venting114218093ve_nting
wanning113816213wann_ing
weaning114117193wean_ing
weanling12118643weanling
weening114113973ween_ing
wenching17328863wenching
wending123816843we_nding
whinnying19172733whinnying
winning113516553winn_ing
wonning113210793wonn_ing
yeaning113814633yean_ing
yeanling12107063yeanling

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621876.56322270.6
3Display Results1871870.0802337.5
 (SQL Overall)1786911877.04925349.8
 
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.