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

159 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
helleris11301018(None) 
helleri10389971helleri_
helleries122611681helleries
hellers103619831heller_s
fellers104117542feller_s
healers104319462healer_s
heelers103815622heeler_s
heller93322512heller__
hellery13329212heller_y
helpers123311852helper_s
hillers103718732hiller_s
hollers103818232holler_s
hullers103616262huller_s
sellers73721312seller_s
shellers112812572sheller_s
tellers73717592teller_s
yellers103912952yeller_s
ballers94421013baller_s
beliers94617383belier_s
belleeks1444363belleeks
belles85325993belle__s
belletrist1254923belletrist
belters93819413belter_s
berberis1246603berberis
billers94720833biller_s
callers94221963caller_s
ceilers93912533ceiler_s
celeries10316313ce_leries
cellars93713693cellar_s
chillers133710923chiller_s
cullers93418853culler_s
dealers84118613dealer_s
delvers113411993delver_s
duellers9268223dueller_s
dwellers12356083dweller_s
elders74817303_elder_s
elemis8312383_e_lemis
elvers93814983_elver_s
fallers103917993faller_s
feelers103814743feeler_s
feller94419553feller__
fillers104320213filler_s
fuellers11277983fueller_s
fulleries1248723fulleries
fullers103817373fuller_s
galleria946473galleria
gallerias1047133gallerias
galleries10311703galleries
gelders93812573gelder_s
gillers84216903giller_s
hailers104017263hailer_s
halberds1435183halberds
halberts1335973halberts
halers94926913h_aler_s
hallels103310133halle_ls
halteres113414593halteres
halters104619803halter_s
halvers133311423halver_s
haulers104012443hauler_s
headers113819393header_s
healer94221803healer__
heapers123616673heaper_s
hearers104319783hearer_s
heaters104225223heater_s
heavers133717193heaver_s
hecklers17357123heckler_s
heders104119763he_der_s
hedgers124310263hedger_s
heeders114213743heeder_s
heeler93917313heeler__
heelless11257653heelle_ss
hefters134312003hefter_s
hegaris11310433he_garis
heifers1337933heifer_s
hellcats1346323hellcats
hellebores1554123hellebores
helled104024703helle__d
hellenize2144713hellenize
hellenizes2244913hellenizes
hellfire1464263hellfire
hellfires1564463hellfires
hellions11310023hellions
hellish13310723hell__ish
helloes103717463hell_oes
hellos95321683hell__os
hells85032043hell___s
helmets12309073helme_ts
helmless1334273helmle_ss
helotries1269563helotries
helper114313093helper__
helpless1335063helple_ss
helves124316063helve__s
hemmers143310843hemmer_s
henleys1334843henle_ys
henneries1248643henneries
herders113914123herder_s
hetaeras1146733hetaeras
hetaeric1346763hetaeric
hetaerism1445413hetaerism
heteros10312683he_teros
hewers123715273he_wer_s
hexereis1894803he_xereis
hexers165612753he_xer_s
hiller94421633hiller__
holders113715903holder_s
holler93520613holler__
hollered1237603hollered
hollering1337743hollering
howlers133312353howler_s
huller93919103huller__
hurlers103714323hurler_s
keglers12277773kegler_s
kelters113813753kelter_s
killers114215583killer_s
lollers72713793loller_s
lullers73213353luller_s
melders103213913melder_s
melters93918313melter_s
mewlers12288983mewler_s
millers93621343miller_s
mullers93217303muller_s
pedleries1298783pedleries
pedlers103013273pedler_s
peelers93615593peeler_s
pelletise1146663pelletise
pellets94014783pelle_ts
pelters93720313pelter_s
phellems1544543phelle_ms
pollers93420023poller_s
pullers93618483puller_s
quellers17237533queller_s
reelers73520273reeler_s
reliers75519213relier_s
rellenos8125493rellenos
rollers73117473roller_s
sealeries9313133sealeries
sealers74323553sealer_s
seller63824593seller__
selles64426983selle__s
sheller103515883sheller__
shelters113412813shelter_s
shelvers14388813shelver_s
sillers73822103siller_s
smellers10329763smeller_s
spellers102812753speller_s
telesis7310793te_lesis
telfers10299073telfer_s
teller63519813teller__
telluric1044113telluric
tillers73418743tiller_s
tollers73217463toller_s
vealers103214293vealer_s
veilers103911823veiler_s
welders113313413welder_s
welters103516063welter_s
wheelers14287733wheeler_s
willers103517913willer_s
yeller94214513yeller__
yelpers12348203yelper_s

Search took 9 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.423422437.4
2DLD Change Limit1461621598.15617920.8
3Display Results1591590.0632523.8
 (SQL Overall)1786911598.64220677.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.