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

123 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
hellers10361983(None) 
fellers104117541fellers
healers104319461healers
heelers103815621heelers
heller93322511heller_
helleri10389971helleri
helleris113010181helleris
hellery13329211hellery
helpers123311851helpers
hillers103718731hillers
hollers103818231hollers
hullers103616261hullers
sellers73721321sellers
shellers112812581shellers
tellers73717601tellers
yellers103912951yellers
ballers94421012ballers
beliers94617382beliers
belles85325992belle_s
belters93819412belters
billers94720832billers
callers94221962callers
ceilers93912532ceilers
cellars93713692cellars
chillers133710922chillers
cullers93418852cullers
dealers84118612dealers
delvers113411992delvers
duellers9268222duellers
dwellers12356082dwellers
elders74817302_elders
elvers93814982_elvers
fallers103917992fallers
feelers103814742feelers
feller94419552feller_
fillers104320212fillers
fuellers11277982fuellers
fullers103817372fullers
gelders93812572gelders
gillers84216902gillers
hailers104017262hailers
halers94926912h_alers
hallels103310132hallels
halters104619802halters
halvers133311422halvers
haulers104012442haulers
headers113819392headers
healer94221802healer_
heapers123616672heapers
hearers104319782hearers
heaters104225222heaters
heavers133717192heavers
hecklers17357122hecklers
heders104119762he_ders
hedgers124310262hedgers
heeders114213742heeders
heeler93917312heeler_
heelless11257652heelless
hefters134312002hefters
heifers1337932heifers
helled104024702helle_d
helleries122611682helleries
helloes103717462helloes
hellos95321682hell_os
hells85032042hell__s
helmets12309072helmets
helmless1334272helmless
helper114313092helper_
helpless1335062helpless
helves124316062helve_s
hemmers143310842hemmers
henleys1334842henleys
herders113914122herders
hewers123715272he_wers
hexers165612752he_xers
hiller94421632hiller_
holders113715902holders
holler93520612holler_
howlers133312352howlers
huller93919102huller_
hurlers103714322hurlers
keglers12277772keglers
kelters113813752kelters
killers114215582killers
lollers72713792lollers
lullers73213352lullers
melders103213912melders
melters93918312melters
mewlers12288982mewlers
millers93621342millers
mullers93217302mullers
pedlers103013272pedlers
peelers93615592peelers
pellets94014782pellets
pelters93720312pelters
phellems1544542phellems
pollers93420022pollers
pullers93618482pullers
quellers17237532quellers
reelers73520272reelers
reliers75519212reliers
rollers73117472rollers
sealers74323552sealers
seller63824602seller_
selles64426982selle_s
sheller103515892sheller_
shelters113412812shelters
shelvers14388812shelvers
sillers73822102sillers
smellers10329772smellers
spellers102812762spellers
telfers10299072telfers
teller63519822teller_
tillers73418742tillers
tollers73217462tollers
vealers103214292vealers
veilers103911822veilers
welders113313412welders
welters103516062welters
wheelers14287732wheelers
willers103517912willers
yeller94214512yeller_
yelpers12348202yelpers

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711232.92036873.6
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.34253468.3
 
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.