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

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
knollers1225514(None) 
knoller11285911knoller_
enrollers976172enrollers
hollers103818232_hollers
killers114215582k_illers
kneelers12226212kneelers
knockers13285732knockers
knolled12296572knolle_d
knolls10367412knoll__s
knotless1264572knotless
knotters12276152knotters
knowers1436352kno_wers
krullers1234132krullers
lollers72713792_lollers
pollers93420022_pollers
rollers73117472_rollers
tollers73217462_tollers
trollers83211212trollers
anglers84014823an_glers
anoles64827433ano_le_s
antlers74014743an_tlers
ballers94421013_ballers
billers94720833_billers
boilers93417063_boilers
bolters94017803_bolters
boodlers113710743boodlers
bowlers123715783_bowlers
broilers103210093broilers
callers94221963_callers
canallers1137213canallers
carollers1137703carollers
chillers133710923chillers
cholers124215203cho_lers
coalers94419353_coalers
coilers93619903_coilers
collars93816573_collars
collets93517903_collets
colliers103613583_colliers
colters93522443_colters
coolers93522493_coolers
crullers1047303crullers
cullers93418853_cullers
diallers957773diallers
dollars83311023_dollars
doodlers10338843doodlers
drillers9429723drillers
droller84110283droller_
drollery12314793drollery
duellers9268223duellers
dwellers12356083dwellers
enablers10196913enablers
enfolders1395093enfolders
ennoblers1143193ennoblers
enrollees974323enrollees
enroller867183enroller_
evolvers14264773evolvers
extollers1663853extollers
fallers103917993_fallers
fellers104117543_fellers
fillers104320213_fillers
folders113514393_folders
folles93820473_folle_s
fondlers12338023fondlers
footlers113910793footlers
foozlers20346073foozlers
fowlers133411203_fowlers
frillers11349873frillers
fuellers11277983fuellers
fullers103817373_fullers
gaolers83511563gao_lers
gillers84216903_gillers
golfers114410083_golfers
grillers93810813grillers
growlers12327093growlers
hellers103619833_hellers
hillers103718733_hillers
holders113715903_holders
holler93520613_holler_
howlers133312353_howlers
hullers103616263_hullers
infolders1385173infolders
inhalers1166643inhalers
inholders1345353inholders
inliers73110743in_liers
involvers1544033involvers
jolliers15357433_jolliers
jolters143711993_jolters
keelless12236193keelless
kegelers1355163kegelers
keglers12277773k_eglers
kelters113813753k_elters
killer104917953k_iller_
kilters113813603k_ilters
kindlers13318483kindlers
knackers13286843knackers
knappers16315643knappers
kneaders1384713kneaders
kneeler11277573kneeler_
knelled12338993knelle_d
knells10439253knell__s
knickers13306723knickers
knifers14537083kn_ifers
knitters12336623knitters
knocker12296393knocker_
knockless1442443knockless
knoll9389603knoll___
knolling13206893knolling
knolly13336133knoll__y
knotter11317643knotter_
knower1337083kno_wer_
knucklers1483043knucklers
koshers144811803k_oshers
kruller1145153kruller_
loller63315283_loller_
lullers73213353_lullers
millers93621343_millers
moilers93615203_moilers
molders103315553_molders
molters93816973_molters
mullers93217303_mullers
nailers73215893_nailers
nobblers12318563_nobblers
nobler83713453_nobler_
nobles83319723_noble_s
nodders94410263_nodders
noosers74913933_noosers
noshers103614333_noshers
noters64021003_no_ters
oglers74313183__oglers
oilers64721193__oilers
peoplers1237163peoplers
polders103617373_polders
polers84225643_po_lers
pollees93215333_pollees
pollens93713303_pollens
poller83921853_poller_
poolers94217423_poolers
prowlers13328933prowlers
pullers93618483_pullers
quellers17237533quellers
rerollers9207123rerollers
rolfers104011813_rolfers
roller63919793_roller_
scolders11288993scolders
scowlers13257373scowlers
scullers103510483scullers
sellers73721323_sellers
shellers112812583shellers
sillers73822103_sillers
smellers10329773smellers
smolders11287193smolders
snarlers8298753snarlers
sneller73512853sneller_
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorers74313803sno_rers
snorters83410583snorters
snowless1145633snowless
solders83517773_solders
solvers104414253_solvers
spallers102910733spallers
spellers102812763spellers
spillers103311703spillers
spoilers10238633spoilers
spoolers10349363spoolers
stollens835293stollens
strollers937553strollers
swillers11299113swillers
tellers73717603_tellers
tillers73418743_tillers
toilers74116263_toilers
toller63819443_toller_
toolers74416503_toolers
toolless836343toolless
tootlers8289503tootlers
trillers83613493trillers
troller73913173troller_
trolleys11315693trolleys
unfolders1344723unfolders
unsolders1064693unsolders
volleys13316643_volleys
willers103517913_willers
wolfers13409633_wolfers
wolvers13349313_wolvers
woolers104214023_woolers
woollens1144093woollens
yellers103912953_yellers
yodlers11298923_yodlers
yowlers13328923_yowlers

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.453394461.4
2DLD Change Limit1461621907.67319048.9
3Display Results1901900.0762500.0
 (SQL Overall)1786911908.20221786.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.