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

251 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
dwellers1235608(None) 
duellers9268221duellers
dweller11297271dweller_
dealers84118612d_ealers
delvers113411992d_elvers
diallers957772diallers
drillers9429712drillers
duelers83412052due_lers
dueller8329832dueller_
dwelled12337592dwelle_d
dwells10417712dwell__s
fellers104117542_fellers
fuellers11277982fuellers
hellers103619832_hellers
indwellers1472352indwellers
jewellers1943532jewellers
quellers17237532quellers
sellers73721302_sellers
shellers112812562shellers
smellers10329752smellers
spellers102812742spellers
sweller103012462sweller_
swelters113110192swelters
swillers11299102swillers
tellers73717582_tellers
welders113313412_welders
welters103516062_welters
willers103517902_willers
yellers103912952_yellers
ateliers837883ateliers
aweless1038723awe_less
ballers94421013_ballers
beetlers1037393beetlers
beliers94617383_beliers
belles85325993_belle_s
belters93819413_belters
bevellers14276113bevellers
billers94720823_billers
bowelless1443833bowelless
callers94221963_callers
ceilers93912533_ceilers
cellars93713693_cellars
chillers133710913chillers
crullers1047293crullers
cullers93418843_cullers
cupellers1374863cupellers
dabblers13379363dabblers
dalles74222063d_alle_s
dalliers93610613dalliers
dandlers103912053dandlers
danglers103610593danglers
dawdlers13375673dawdlers
dazzlers1733233dazzlers
dealer74122143d_ealer_
deckers144413833d_eckers
deedless10318253deedless
deers64930523d_e__ers
defers105116943d_e_fers
defiers113913993d_efiers
defilers12439473defilers
defleas1147223d_efleas
deicers103612733d_eicers
delayers12268663d_elayers
deles65139253d_e_le_s
delivers123310753d_elivers
dellies83622213d_ellies
dells66630943d_ell__s
deluders10156433d_eluders
delver104913493d_elver_
delves104917083d_elve_s
deniers84515183d_eniers
deters74724683d_e_ters
dewaters122910713dewaters
dewless1137473d_ewless
dialers83614293d_ialers
dialler848813dialler_
dibblers13377583dibblers
diddlers11359153diddlers
diesters92513593diesters
dieters83216423die_ters
diethers1257453diethers
dispellers13115443dispellers
dollars83311023d_ollars
doodlers10338843doodlers
doublers11288493doublers
dowelled1356343dowelle_d
dowerless1344013dowerless
drawlers12307313drawlers
dreamers11369003dreamers
dredgers11256093dredgers
dressers9359863dressers
driller84311883driller_
drivellers1452953drivellers
droller84110283droller_
drollery12314793drollery
dueler74213683due_ler_
duelled9359753duelle_d
duellos845763duell_os
duller74017703d_uller_
duxelles1643963duxelle_s
dweebs1233653dwe__ebs
dwell9519853dwell___
dwelling13368413dwelling
dwellings14244213dwellings
elders74817303__elders
elvers93814983__elvers
expellers18104743expellers
fallers103917993_fallers
feelers103814743_feelers
feller94419553_feller_
fielders12156773fielders
fillers104320203_fillers
frillers11349863frillers
fuelers103912393fue_lers
fueller10279963fueller_
fullers103817373_fullers
gelders93812573_gelders
gillers84216893_gillers
grillers93810803grillers
gruellers1034183gruellers
healers104319463_healers
heelers103815623_heelers
heelless11257653heelless
heller93322513_heller_
helleri10389973_helleri
helleris113010183_helleris
hellery13329213_hellery
helpers123311853_helpers
hillers103718723_hillers
hollers103818233_hollers
hullers103616263_hullers
impellers1345103impellers
indweller1393013indweller_
jewelers1834713jewelers
jeweller1844123jeweller_
jewellery2241823jewellery
keelless12236193keelless
keglers12277773_keglers
kelters113813753_kelters
killers114215573_killers
kneelers12226213kneelers
knollers12255133knollers
krullers1234133krullers
labellers11206553labellers
levellers12286043levellers
libellers11236033libellers
lollers72713793_lollers
lullers73213353_lullers
melders103213913_melders
melters93918313_melters
mewlers12288983_mewlers
millers93621333_millers
modellers1245393modellers
mullers93217303_mullers
needlers9287423needlers
pedlers103013273_pedlers
peelers93615593_peelers
pellets94014783_pellets
pelters93720313_pelters
phellems1544543phellems
pollers93420023_pollers
pullers93618483_pullers
queller16289293queller_
ravellers12257163ravellers
reelers73520273_reelers
reliers75519213_reliers
repellers11278873repellers
resellers9299903resellers
revellers12319503revellers
rollers73117473_rollers
scullers103510473scullers
sealers74323553_sealers
seller63824593_seller_
selles64426983_selle_s
sheller103515883sheller_
shelters113412803shelters
shelvers14388813shelvers
sillers73822093_sillers
skelters12349373skelters
smeller94212783smeller_
smelters103310513smelters
sneller73512843sneller_
spallers102910723spallers
speller95415143speller_
spelters103912243spelters
spillers103311693spillers
stealers83412193stealers
swearers11328583swearers
sweaters113811053sweaters
sweepers13348163sweepers
swelled113211693swelle_d
swellest1137663swellest
swells93913983swell__s
swelter103711173swelter_
swervers1455213swervers
swiller103211653swiller_
telfers10299073_telfers
teller63519813_teller_
tillers73418733_tillers
tollers73217453_tollers
trillers83613483trillers
trollers83211203trollers
trowellers1343653trowellers
tweeners11306243tweeners
tweeters11287143tweeters
tweezers20254383tweezers
twelves1334303twelve_s
twirlers11274303twirlers
vealers103214293_vealers
veilers103911823_veilers
wailers103916803_wailers
walers94824463_w_alers
walkers143411473_walkers
wallets103914833_wallets
weaners104613833_weaners
wearers104615903_wearers
weavers133714463_weavers
webers11310943_we_bers
webless1237003_webless
wedders123610723_wedders
weeders113412933_weeders
weepers123511973_weepers
weevers13379993_weevers
weiners103913063_weiners
welchers16338053_welchers
welder102914413_welder_
weldless12285813_weldless
weldors11238003_weldors
welldoers1343193_welldoers
welled103820213_welle_d
wellies103719073_wellies
wellness1135793_wellness
wells85426193_well__s
welshers14246813_welshers
welter93417383_welter_
westers105221963_westers
wethers135214693_wethers
wetters103817753_wetters
whalers13529703_whalers
wheelers14287733wheelers
wielders12196613wielders
wilders113513503_wilders
willer94021063_willer_
willets104414323_willets
wolfers13409633_wolfers
wolvers13349313_wolvers
woolers104214023_woolers
yeller94214513_yeller_
yelpers12348203_yelpers
yielders12164743yielders
yodellers1343973yodellers

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.1561145455.1
2DLD Change Limit1461622517.53319402.9
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.78222962.1
 
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.